Forum Discussion
Solved
Help with Card Data Type Formats
Hi all, I am working on something that is a little fun but I have reached a point where I am a little "flummoxed". It is essentially a simple report based on 4Dx which allows users to define ...
Hi BrendonHerbert ,
FORMAT operates on numeric values. So FORMAT(<value> ,"Standard") will display the value with thousand separators only if the value is of type numeric. In your case all the values are of type text, although the content is numeric. So this approach will not work.
You could change the measure as follows
var Parameter = "KPI target"
var Stage1 = LOOKUPVALUE( Your original expression)
var Stage2 = CONVERT (Stage1, DOUBLE)
return
FORMAT(Stage2, "Standard")
Check it out and let me know.
Cheers
CheenuSing
Hi,
You can create separate table for numeric values when you query this table.
Cheers