Expression result even others are conditional

[surajap123]

Hi All,

I have these 3 exprssions in my straight table. I made the column 1 and 2 as conditional(enable conditional checkbox in exprssion tab). So due to this my 3rd expression is not working.

1. sum({<Year=, Quarter=, Month=, field=p({$<Year=, Quarter=, Month=>} field)>} sales)])

2. sum({<Year=, Quarter=,Month=,field=p({$<Year=, Quarter=,Month=>} field) >} sales)])

3. if ( Column (2) = 0 , '-' , column(1) / column (2) )

How can i write the 3rd expression(or some settings), so that it will show values all the time??

[maxgro · Accepted solution]

maybe

if(

sum({<Year=, Quarter=,Month=,field=p({$<Year=, Quarter=,Month=>} field) >} sales)])=0,

'∞',

sum({<Year=, Quarter=,Month=,field=p({$<Year=, Quarter=,Month=>} field) >} sales)])

  /

sum({<Year=, Quarter=,Month=,field=p({$<Year=, Quarter=,Month=>} field) >} sales)])

)

itsn't clear to me why you have expr1 = expr2

[surajap123]

Thanks !!