Total sum wont come after applying the expression!

[nevilledhamsiri]

Hi,

Dear guys,

I need to get the sum by applying the formula given below. Can someone to suggest me where I should modify this expression. What I simply need is to if the Actual is greater than the budget, for the all stated telephone numbers for the stated Months, to calculate the amount to be recovered. I get the exact output but the issue is it wont get the sum in the row. I may attach the related pivot table for your reference as well.

IF(Actual>BUDGET,SUM({<Telephone_number={'077_4352506','077_3139047','077_2980266','077_6942156','077_3139049'},Month={'January','February','March','Ápril','May','June'}>}(Actual-BUDGET*1)),0)

Neville

[nevilledhamsiri]

Can some one please help me on this!. This is a urgent case!

Regards!

Neville

[Neymar_Jr]

Hi,

Can you please share a sample app or sample data?

Thank you!

[swuehl · Accepted solution]

Maybe

SUM({<Telephone_number={'077_4352506','077_3139047','077_2980266','077_6942156','077_3139049'},Month={'January','February','March','Ápril','May','June'}>}

IF(Actual>BUDGET,(Actual-BUDGET*1),0)

)

Use Aggregation Functions!

[its_anandrjs]

Or may be try this one need to know where using expression

=IF(Sum( TOTAL Actual) > Sum( TOTAL BUDGET), SUM({<Telephone_number={'077_4352506','077_3139047','077_2980266','077_6942156','077_3139049'},

                                   Month={'January','February','March','Ápril','May','June'}>}(Actual-BUDGET*1)),0)

Or

SUM({<Telephone_number={'077_4352506','077_3139047','077_2980266','077_6942156','077_3139049'},Month={'January','February','March','Ápril','May','June'}>}

IF(Actual>BUDGET,(Actual-BUDGET*1),0)

)