Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
!
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%')
)
Try this expression:
IF (%agg = 'sum'
,num(sum({$< QuoteSummaryKPIType = {'Cover Type'} , QuoteSummaryKPIDetails = > } $(=%metric)),'#,##0')
,num(avg({$< QuoteSummaryKPIType = {'Cover Type'} , QuoteSummaryKPIDetails = > } $(=%metric)) ,'#,##%')
)
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!
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%')
)
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.