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.
Hi try like this
if(Status= 'Open' ,DataColumn1 ) - if(Status = 'Open', DataColumn2)
Hi Amelia,
I have a small doubt can u please check
Status='open' here i am expecting (small) o or is it O
if data is there then check first like =if(Status='Open',4-2) [now u got all values are 2 else your data is wrong].
after that u can check like below
=if(Status='Open',num(DataColumn1)-num(DataColumn2))
Thanks. Values are showing corresponding to Data1, Data2, Data3 as below.
Week | CustomerID | Data1 | Data2 | Data3 |
1 | 5254 | 18.0 | ||
1 | 908 | 17 | ||
1 | 434 | 48 | ||
1 | 1434 | 30.5 | ||
1 | 45 | 20.9 | ||
1 | 434 | 29.3 | ||
1 | 3543 | 42.4 | ||
1 | 7676 | 30.7 | ||
1 | 67657 | 102 | ||
1 | 674 | 99 | ||
2 | 9078 | 52 | ||
2 | 565 | 102 | ||
2 | 5757 | 63 | ||
3 | 6767 | 107 | ||
3 | 7845765 | 100 | ||
3 | 8568 | 54 | ||
3 | 6856 | 14.5 | ||
3 | 5756 | 17.2 | ||
3 | 856 | 79 | ||
3 | 7856 | 34.9 | ||
4 | 68 | 106 | ||
4 | 12 | 80 | ||
1 | 865 | 91 | ||
1 | 787 | 108 | ||
1 | 6586 | 80 | ||
1 | 85 | |||
1 | 7568 | 78 | ||
1 | 65856 | 106 | ||
2 | 7856 | 80 | ||
2 | 44634 | 82 | ||
2 | 897 | 84 | ||
2 | 8657 | 75 | ||
2 | 686 | 93 | ||
2 | 45 | |||
2 | 34 | 98 |
is there any way to change the above table with out blanks and to keep only values. I am thinking whether is it possible or not because of different CustomerID. Please suggest me
HI,
It is not possible, because you have different customers in each row, if you remove the Customer dimension then you get the expected result but I think you definitely need it.
Regards,
Jagan.
Thanks.