Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using an expression to set the format of certain cells, this works fine. In the expression there is also a set analysis to ignore certain selections. This works also fine.
However when a selection is done in a field which is ignored by the set analysis the formatting disappears expect for the selected value.
Below is a shortened version of the expression:
if(Ratio=20, Money(sum({$<Specialisme_omschrijving_conc=>}noemer),'€ #.##0'),
if(Ratio=23, num(sum({$<Specialisme_omschrijving_conc=>}noemer),'#.##0,0%')
))
So when a selection is done in the field Specialisme_omschrijving_conc the selection is ignored (as it should), however the formatting disappears except for the selected value of Specialisme_omschrijving_conc.
Does anyone know how to fix this. I want to keep the formatting for all dimension not just the selected one.
gr.
Frank
Hi Frank
Have the exact same issue - a shame no one have come with a solution to your issue.
Regards
Soren