Help with adding formatting to a measure

[Anonymous]

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

[ahaahaaha]

Hi Peggy,

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

Regards,

Andrey

[anushree1]

Hi,

Please try this:

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

[Anonymous]

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]

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

[Anonymous]

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

[Anonymous]

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

[anushree1]

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]

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

[anushree1]

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