Good day -
I am having an issue when attempting to use embedded formatting with NUM() in an expression. The expression I am using is:
=if(vTest='Numbers',
NUM((count(distinct{<Score={'>8'}, SentimentScore={'>3'}>}Record_ID)), '#,##0.0') ,
NUM( ((count(distinct{<Score={'>8'}, Sentiment={'>3'}>}Record_ID)) /(Count({$<Category2 = >} Record_ID))), '#,##0%'))
I have the Number formatting on the chart set to "Measure Expression" (This is a Vizlib chart).
The numbers calculate correctly when viewed in a table, but only the first value formats correctly.
The second value formats with an "m" - e.g. "34m".
If anyone has any ideas on what this might be and how to resolve, it would be much appreciated.
Thanks!