Formatting altered when using a dynamic expression

[#1]

Hi

I have an app where the user can choose the data shown in a chart  / table based on an inline loaded list.  I don't seem to be able to get any consistent formatting!  As in the attached app, when I choose one of the metrics that are ratios, then all is good.  The minute I try to use the formats that are straight summed values I often get exponential notations,  or what have you.

Any ideas?

Cheers

!

[Gysbert_Wassenaar]

Try this expression:

IF (%agg  = 'sum'

,num(sum({$< QuoteSummaryKPIType  = {'Cover Type'} , QuoteSummaryKPIDetails =    > }  $(=%metric)),'#,##0') 

,num(avg({$< QuoteSummaryKPIType  = {'Cover Type'} , QuoteSummaryKPIDetails =    > } $(=%metric)) ,'#,##%')

)

[#3]

Excellent! That worked, and I should have worked it out....

However.. I've noticed the issue can be recreated even when the formatting has been fixed, by clicking on the QuoteSummaryKPIDetails  column. 

I used  'QuoteSummaryKPIDetails =    >'  in the set analysis, so it doesn't filter the data, but it still affects the formatting, which is quite odd!  Any more ideas?  Cheers!

[Gysbert_Wassenaar · Accepted solution]

Try this:

If

(only({$< QuoteSummaryKPIType  = {'Cover Type'} , QuoteSummaryKPIDetails =    > } %agg)  = 'sum'
,num(sum({$< QuoteSummaryKPIType  = {'Cover Type'} , QuoteSummaryKPIDetails =    > }  $(=%metric)),'#,##0') 
,num(avg({$< QuoteSummaryKPIType  = {'Cover Type'} , QuoteSummaryKPIDetails =    > } $(=%metric)) ,'#,##0%')
)

[#5]

Fantastic! Cheers.. much appreciated.  So you need to put the output from the selection that is used in set analysis too? Good to remember that! Thanks again.