Forum Discussion

RMDNA's avatar
RMDNA
Icon for Solution Sage rankSolution Sage
8 years ago
Solved

Changing value type within a measure just for display

Hi all,   I'm creating in-table KPIs using a mesaure in order to add a colored box inside the cell (and avoid the full-cell color background).   [ Spoiler ] The measure to create this visual is ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Can you nest formats like such?

     

    FORMAT ( FORMAT([New Accounts_PL % WTD],"Percent") & " " & Indicator, 0 )

    Hope this helps,

    Parker

RMDNA's avatar
RMDNA
Icon for Solution Sage rankSolution Sage
8 years ago

Anonymous,

 

That seems to work (at least in initial testing); is there a way to specify how many decimals places are used?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I've never done it but apparently it can be done with the FIXED function.

 

FIXED(<number>, <decimals>, <no_commas>)