Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
I have define a set expression which works on specific condition, but it doesn't work on row level without condition:
eg: (sum({<Year = {2017},Item = {'Books'}>}sales)-sum({<Year = {2018},Item = {'Books'}>}sales))*sum({<Year = {2018}>}amount) --> this expression works.
but the same expression on row level in a table without condition doesn't gives the expected result.
eg: (sum({<Year = {2017}>}sales)-sum({<Year = {2018}>}sales))*sum({<Year = {2018}>}amount) --> this expression works.
Do i need to add some other expression to my current set expression, kindly advise.
Thanks,
MAK.
i was able to solve the expression, please see below:
sum(<Item>sales)/sum(<Item>amount)
You have only Item dimension or anything else?
One item condition was just an example, to check if the expression works...
i was able to solve the expression, please see below:
sum(<Item>sales)/sum(<Item>amount)