Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
)
Can some one please help me on this!. This is a urgent case!
Regards!
Neville
Hi,
Can you please share a sample app or sample data?
Thank you!
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)
)
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)
)