Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
For pick 2 (Highlight Section), how do I format so that there is a $ in front of the number in the graph? Its on Auto formatting.
Try something like this but you have to modify your expression accordingly
=Pick(1, Field1, Num(Pick(2, Field2, Field3), '$#,##0.00'), Field4)
In the "Format pattern" field, enter the following pattern: '$'#,##0.00.
That make all the pick have $ in front of them, I only want it for the second pick.
Hi @Noor51 ,
Try this
num($(Salesmeasure),'$#,##0') in position 2.
Thanks,
Hi @Sivapriya_d,
Love the Profile picture. I tried that expression, but it didn't work.
Best Regards,
Try something like this but you have to modify your expression accordingly
=Pick(1, Field1, Num(Pick(2, Field2, Field3), '$#,##0.00'), Field4)