Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Help with adding formatting to a measure

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

11 Replies
Anonymous
Not applicable
Author

Well finally... Thanks for the teaching me this. Please see the waterfall walk.  I am unable to change the format on the starting and ending column because of the design of the object settings.  The formatting is not an option, but I am attempting to modify the format in the measures statement. Looking forward to feedback.

Anonymous
Not applicable
Author

I hope to hear from you as well if possible.  Thanks!