Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI
I just want to hide a column (expression ) where the values are null and i'm uisng version QV 10
please see the attached file
i want ot hide the YE 2012 Statutory column where all the values are nulls
I'm afraid thats not possible. The expressions will be shown for each value of COST TYPE. Even if expression returns only nulls for all rows. You could try combining your two expressions into one.
if(COST_TYPE='YE 2012',
Sum(ELEMENT_ITEM_COST)
Sum( if(COST_TYPE like 'Frozen',ELEMENT_ITEM_COST, null())) - Sum( if(COST_SUB_ELEMENT like 'MTP',ELEMENT_ITEM_COST, Null()))
)
you are right .. even i felt the same .....but at end user point that doesn't make any sense to show a null values column...
Anyway just want to give it a try for any workaround suggestion...
Thanks for your reply