Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I have to write a expression based on below condition
IF Status='Open' then NUM(DataColumn1-DataColumn2)
I am trying to use if(Status=Open', NUM(DataColumn1-DataColumn2)). But straight table column is showing blank. table is not loading any data. Is there any error in expression? please can anyone suggest me
Thanks.
Try this may be:
Dimension:
1) Week(EnterDate)
2) CustomerID
Expressions:
Data1: Num(Only({<Status = {'Open'}>}DataColumn1)-Only({<Status = {'Open'}>}DataColumn2))
Data2: Num(Only({<Status = {'Closed'}>}DataColumn1)-Only({<Status = {'Closed'}>}DataColumn2))
Data3: Num(Only({<Status = {'Required'}>}DataColumn1)-Only({<Status = {'Required'}>}DataColumn2))
May be try this:
=Only({<Status = {'Open'}>} DataColumn1 - DataColumn2)
Hi,
Try the below one and see also the attached app,Hope it helps!!
=if(Status='Open',num(DataColumn1)-num(DataColumn2))
Thanks. Tried this. still showing blanks
Thanks. Tried this. still showing blanks
Give this a try
=if(Match(Status,'Open'), Num(DataColumn1) - Num(DataColumn2))
Could you post your sample app?
which is your dimension?, each category in your dimension can only have one status?
missing single quote.
regards
Marco
dimension is only below one
Week(EnterDate)