Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a "IF" condition formula for measure "MTH-REV [US$]" set as:
if(Customer='A' OR Customer='B', 'US$43,000', (Sum({$<Month={"=$(=Max([Month]))"}, Customer=-{'A','B'}>} Revenue)))
In the "Table" chart , the "Total" amount is not adding the revenue total including the revenue for Customers 'A' and 'B'
Customer | MTH-REV [US$] |
Total | US$57,086 |
A | US$43,000 |
B | US$43,000 |
D | US$27,632 |
E | US$10,344 |
C | US$9,610 |
F | US$7,927 |
G | US$1,574 |
how should I correct the formula in order to correctly reflect the "Total" amount in the chart?
as below
=Sum( Aggr( if(wildmatch(Customer,'A','B'), 43000,Sum({$<Month={"=$(=Max([Month]))"}, Customer=-{'A','B'}>} Revenue) ) , Customer ) )
based on the expression looks like for A or B it is adding it as a text plus it is also removing customers A & B .
try
if(Customer='A' OR Customer='B', 43000, (Sum({$<Month={"=$(=Max([Month]))"}>} Revenue)))
Thanks for the prompt response, but it didn't work.
The total is still showing without adding up the 43,000 x 2 for both customers 'A' and 'B'
as below
=Sum( Aggr( if(wildmatch(Customer,'A','B'), 43000,Sum({$<Month={"=$(=Max([Month]))"}, Customer=-{'A','B'}>} Revenue) ) , Customer ) )