Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
fabs(Sum(if([Transaction Type]='C' and Year=2014 and Month='May' and Week='18','19','20',[Movement Quantity]))
Hope it helps
Hi sujeet,
it was showing error in expression
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?
May be some comma or quotes missing.
OK bracket is missing at right
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]))
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
Hi
Can you post a sample?
Using match is a good way to do so.
Hi Anand,
I am getting all the weeks of Data, and also that column data i am getting Zero.