Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an expression as
sum(Total<A,B,C>Revenue)
I want to put an if condition in the same. When i put if condition in beginning like:
if(Quarter='Q1', sum(Total<A,B,C>Revenue),0)
it does not give any result.
How should i write the expression for it to work.
Had you have a dimension Quarter, your expression would work. Else, try like:
=Sum( TOTAL <A,B,C> If(Quarter='Q1', Revenue,0))
=SUM(TOTAL <A,B,C> {<Quarter = {'Q1'}>} Revenue)
Hi Manish,
In Quarter I am trying to use an Alphanumeric variable. Its not working for that. Any change in syntax required?
Thanks and Regards,
Gaurang.
Quarter = {'$(Variable)'}
Try this
=if(Qtr>0,sum(Total<A,B,C> )Revenue)
sum({$ <Quarter={'$(var)'}>} TOTAL <A,B,C> Revenue)