5 Replies Latest reply on Sep 10, 2018 9:23 AM by Joe Oppelt

    Different number formatting for a calculated field used as measure

    keerthana kumar

      Hi All,


      I have a scenario where  a calculated Field has to shows different number formatting according to dimension value,

      In the below table :

                                    IF Type=Sales then  [AMT]/[BP AMT]   (Number Formatting % with 2 dec points)

                                      elseif type=Stock then [AMT]-[BP AMT]  (Number formatting standard with 2 dec points)


      the calculated Field is done. I  have no idea how to achieve the number formatting .

      If i try to convert into STR and append with % it becomes Discrete and I cant use in Measure values.


      ask ques.JPG