Straight table expression not working?

[#1]

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.

[rajeshforqlikvi]

Hi try like this

if(Status= 'Open' ,DataColumn1 ) - if(Status = 'Open', DataColumn2)

[ramasaisaksoft]

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))

[#4]

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

[jagan]

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.

[#6]

Thanks.