11 Replies Latest reply: May 26, 2017 12:11 AM by Peggy Wells RSS

    Help with adding formatting to a measure

    Peggy Wells

      I am trying to add formatting to a measure.  The formula says it is ok, but the data is missing when you close out of the function writer.  Can you tell me what I may be doing wrong with this set analysis statement with the added formatting???

       

      =num((sum ({$<Scenario={'$(vCurFcst)'},MthNameLong={'$(vCurMth)'}>} Revenue)/1000000));$#,##0.#M;($#,##0.#)M