Number formatting and set analysis

[#1]

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

[skovsgaard]

Hi Frank

Have the exact same issue - a shame no one have come with a solution to your issue.

Regards

Soren