Forum Discussion

brianhackett5's avatar
brianhackett5
Helper I
8 years ago
Solved

Formatting Variable

HIguys,    Just wondring if is possible to format variables depending on the result returned. I've highighted the desired format for each variable in red.    Thanks in advance for your help.    ...
Need Help
  • vik0810's avatar
    vik0810
    8 years ago

    Yes, you can use FORMAT function.

     

    SWITCH(FINANCIAL_KPIs_Link[NUMBER],
       1, FORMAT ( [Price_List_Errors], "#,##" ),
       2,  FORMAT ( [Sales], "#,##0 €" ),
       3, FORMAT(GP, "percent")
)
vik0810's avatar
vik0810
Resolver V
8 years ago

Yes, you can use FORMAT function.

 

SWITCH(FINANCIAL_KPIs_Link[NUMBER],
       1, FORMAT ( [Price_List_Errors], "#,##" ),
       2,  FORMAT ( [Sales], "#,##0 €" ),
       3, FORMAT(GP, "percent")
)