Is there a way to replace the dollar amount with a percentage in a gauge?

[amitch1029]

I have a gauge in my app and it's showing both dollar amount as well as a percent. I would like for it to show percent ONLY.

Can someone please help me with this?

My formula is as follows

=num(Sum({<FLG_IsFiscalQTD={1}>} [Sales Target Credit])/Sum({<FLG_IsCYCQ={1}>} [Quota]),'###.0%')

[Lisa_P]

Can you attach a screenshot ?

[Rodj]

Hi @amitch1029 ,

What do you have your number formatting option set to (Measures --> your measure --> Number formatting).  your number formatting string looks valid but won't be used unless you "measure expression" in the number formatting option. You can do away with the num function altogether by using the "number" option instead of measure expression and then pick the format pattern you want under that. 

If that's not sorted it out then a screenshot of what options you have etc would be useful.

Cheers,

Rod

[amitch1029]

Thank you SO much Rod, changing the number formatting to Measure Expression worked like a charm!

Ashley

[Rodj]

No worries Ashley, I've been there myself.

Please don't forget to mark the solution so that it might help others in future.

Cheers,

Rod