topic Re: How to add currency symbol before values in chart in App Development

How to add currency symbol before values in chart

Rachel_F — Fri, 15 Nov 2024 21:40:19 GMT

How to add currency symbol before values in chart

I have generated a graph to show money values as shown below. But I am not able to add currency symbol before the amount on Y-axis.

The expression I used is

=Dual('$'&Num(Sum(Award Amount)/Pow(10,3*Div(Log10(Fabs(Sum(Award Amount))),3)),'#,##0.0')&' '&Pick(Div(Log10(Fabs(Sum(Award Amount))),3),'K','M','B','T'), Sum(Award Amount)),

how can I modify this to get currency symbol on Y-axis.

Re: How to add currency symbol before values in chart

rubenmarin — Sun, 18 Jun 2023 07:00:21 GMT

Hi, you can try adding it to the num function: '$#,##0.0'. And use the num function in both dual parameters

Re: How to add currency symbol before values in chart

Rachel_F — Fri, 04 Aug 2023 18:08:01 GMT

Thank you but that did not work for what I was working on.