Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the 3 tables
1st table contains : Customer, Product, Loaded_Currency and List Price.
2nd table contains : EFF_Currency, EFF_CUR_TO, Exchange Rate
3rd table contains : EFF_Currency, Product, Effective Price.
1st table sample data:
2nd table data:
3rd Table:
Now, I need the chart like the Below (Need to shows the two Products and effective price also based on Exchange rate)
i used the expression like the below
=Only([Effective Price])*Only({<EFF_CUR_TO={'$(=Loaded_Currency)'}>}[Exchange Rate]).
But, the result, shows as null... I attached the sample app..
Can you help on this?
Regards,
Settu P
A set analysis expression calculates a set at the chart level, not at the row level. That's why your expression does not work if you don't make a selection first. You can use an if-statement instead: =only(if(EFF_CUR_TO=Loaded_Currency,[Exchange Rate]))*[Effective Price]
A set analysis expression calculates a set at the chart level, not at the row level. That's why your expression does not work if you don't make a selection first. You can use an if-statement instead: =only(if(EFF_CUR_TO=Loaded_Currency,[Exchange Rate]))*[Effective Price]
Thank you Gysbert. I will use if statement.