cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
darraghfarrell Frequent Visitor
Frequent Visitor

Total Column not working

I created a formula, see below, it looks to be working fine on a row but not when i look at the totals column. 

 

HardwareCostAmount = SUMX(VALUES(tMobileRevenue[TotalBilled]), DIVIDE(CALCULATE(SUM(tMobileRevenue[TotalBilled])*.95,tMobileRevenue[ChargeType]="XQ"),SUM(tMobileRevenue[ContractTerm])) + DIVIDE(CALCULATE(SUM(tMobileRevenue[TotalBilled]),tMobileRevenue[ChargeType]="XK")*.5,SUM(tMobileRevenue[ContractTerm])))+0
 
 
1 REPLY 1
Community Support Team
Community Support Team

Re: Total Column not working

Hi @darraghfarrell,

 

It's not very clear about your problem according to current desription. Please post sample data and show us the desired output.

How to Get Your Question Answered Quickly

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.