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



      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?