Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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!