10 Replies Latest reply on May 7, 2018 10:13 AM by David Luhut

    Calculated Measure to dynamically 'change' number format between Number and Percentage

    David Luhut

      Hello,

       

      I created a calculated measure named 'MTD Actual'.

       

      Most of the figures are in numbers. However, there's 2 that's in percentages (Economic Vacancy  or  NOI Margin %).

       

      How can I have the value show to either number or percentages?

       

      I've attached 2 images where initially I have it format to 'Number', and thus any figures that are supposed to be percentages are shown as either 1 (anything that's greater than or equal to 50%) or 0 (anything that's less than 50%).

       

      The default 'Automatic' format makes it worst.

       

      Is there a solution to this?