Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hai,
num(sum([Sales Amount]), '$#,##0') what is the use of $,# in this.Can anyoune clear my dbt.
Thanks in advance
Here, $ - will act as Static
Assume, If your Sales Amount value seems 3403 -- Output you will receive as $3403 //As i said $ is static here. Some users need to show that sales amount into USD Currency they followed this
And # - It act as Format of out data point
#,##0 -- If you have around 3403 -- Then it will give 3,403 //Here, Comma is the special to neat and clean values
Finally you will get like below $3,404
Here, $ - will act as Static
Assume, If your Sales Amount value seems 3403 -- Output you will receive as $3403 //As i said $ is static here. Some users need to show that sales amount into USD Currency they followed this
And # - It act as Format of out data point
#,##0 -- If you have around 3403 -- Then it will give 3,403 //Here, Comma is the special to neat and clean values
Finally you will get like below $3,404
Thanks anil.