4 Replies Latest reply: Sep 17, 2017 2:11 AM by Anand Chouhan

# Total sum wont come after applying the expression!

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

• ###### Re: Total sum wont come after applying the expression!

Regards!

Neville

• ###### Re: Total sum wont come after applying the expression!

Hi,

Can you please share a sample app or sample data?

Thank you!

• ###### Re: Total sum wont come after applying the expression!

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)

)

• ###### Re: Total sum wont come after applying the expression!

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!