Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
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
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
Thanks !!