Using if, sum, Total in the same Expression

[#1]

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.

[tresesco]

Had you have a dimension Quarter, your expression would work. Else, try like:

=Sum( TOTAL <A,B,C> If(Quarter='Q1', Revenue,0))

[MK_QSL]

=SUM(TOTAL <A,B,C> {<Quarter = {'Q1'}>} Revenue)

[#4]

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.

[MK_QSL]

Quarter = {'$(Variable)'}

[sunilkumarqv]

Try this

=if(Qtr>0,sum(Total<A,B,C> )Revenue)

[maxgro]

sum({$ <Quarter={'$(var)'}>} TOTAL <A,B,C> Revenue)