Forum Discussion

BrendonHerbert's avatar
BrendonHerbert
Regular Visitor
6 years ago
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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

     

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

 

 

 

  • BrendonHerbert's avatar
    BrendonHerbert
    Regular Visitor
    6 years ago

    Hi Anonymous  and cjayaneththi ,

     

    thank you both for your responses.  

     

    Anonymous your approach worked perfectly!!

     

    thank you very much