Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have dimension which I only want the value to show when: Sum({<MeasureID={'OMW'},Month=,Year=>}Gap)>0
I have the above expression in the 'Enable Conditional' box, but it's still showing for all Gaps even when not >0.
Have I done something wrong?
Thanks,
Linda
this expression will be calculated without dimension for the whole chart...
you could change your expression:
if(Sum({<MeasureID={'OMW'},Month=,Year=>}Gap)>0 ,Sum({<MeasureID={'OMW'},Month=,Year=>}Gap) )
Thank you. I tried that. The dimension is actually 'DUE_DATE' so I only want the DUE_DATE to show when:
Sum({<MeasureID={'OMW'},Month=,Year=>}Gap)>0 )
Based on your response I tried in the Enable Condition:
if(Sum({<MeasureID={'OMW'},Month=,Year=>}Gap)>0 ,DUE_DATE )
and it also did not work.
no, you must change the expression not the condition for the expression...
I also tried that and I get "// Error in calculated dimension". It is a pivot table and on an individual patient level for each row. Did I miss something in the expression maybe?
please post a sample...
Error in calculated dimension appears , if you use aggregation functions without aggr() in the calculated dimension...
Conditional disables the whole dimension / expression, not only a row...