If stmt ?

[#1]

Hi,

fabs(Sum({<[Transaction Type]={'C'},Year={2014},Month={'May'},Week={'18','19','20'}>}[Movement Quantity]))

Convert this set analysis into if Condition

Regards,

Helen

[sujeetsingh]

fabs(Sum(if([Transaction Type]='C' and Year=2014 and Month='May' and Week='18','19','20',[Movement Quantity]))

Hope it helps

[#3]

Hi sujeet,

it was showing error in expression

[MayilVahanan]

Hi

Try like this

fabs(Sum(if([Transaction Type]='C' and Year=2014 and Month='May' and Match(Week,'18','19','20'),[Movement Quantity])))

But why you need to convert into if statement?

[sujeetsingh]

May be some comma or quotes missing.

OK bracket is missing at right

[its_anandrjs]

Try with this expression also

Fabs(Sum(if([Transaction Type]='C' and Year=2014 and Month='May' and Match(Week,18,19,20),[Movement Quantity]))

[#7]

I am having the data for all weeks, But I want to display the data only for the weeks of May(18,19,20).

It means WTD analysis..

using above Expression i am getting the data for all weeks , i want to display only 18,19,20

[MayilVahanan]

Hi

Can you post a sample?

[sujeetsingh]

Using match is a good way to do so.

[#10]

Hi Anand,

I am getting all the weeks of Data, and also that column data i am getting Zero.