Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
ahaahaaha
Partner - Master
Partner - Master

Hi Peggy,

Can you provide a fragment of the original data and the result that you want to get after formatting?

Regards,

Andrey

anushree1
Specialist II
Specialist II

Hi,

Please try this:

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

Anonymous
Not applicable
Author

Thanks for the recommendation.  I see you added a closed parenthesis at the end.  Should I add the open parenthesis after the equal sign at the start of the equation?  I will try this whe I get in the office!  Again, thanks for the reply!

Anonymous
Not applicable
Author

I would love to.  Let me figure out how.  I'll do that when I get in the office.  Thanks for the reply.

Anonymous
Not applicable
Author

Hi!  How do i attach the app so you can see my issue? 

Anonymous
Not applicable
Author

It didn't work, but I'm still at it.

anushree1
Specialist II
Specialist II

HI Peggy,

You could post the app by clicking on use advanced editor option that appears on the right hand corner after reply option is clicked

Anonymous
Not applicable
Author

You are being very helpful, but I don't have that option in my view. Am I missing something??WhatISee.JPG

anushree1
Specialist II
Specialist II

I think you are directly getting  onto the inbox and replying on the latest thread instead i suggest double click on the thread to open the complete conversation and then hit reply and then you should be able to choose the advanced editor option