How do you add a โ$โ to my field that is coded as โNumberโ? Iโve added $ to my original data file, but canโt seem to get the dollar sign to show up.
Is there a different format to use?
Probably need to set it as a Price column. You can then go into that column attributes and change it to how many decimal points you want to see.
@Stephen_Mattison Thank you!
@Tina_Cheng Welcome!
Usually if you set
up your column in your Sheet as Currency, AS will pick that up and set your Column to Price, sometimes it doesnโt get it just the way you want, probably my fault, haha!.
Occasionally, I need to go into the Column Definition and set my Decimals to zero.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |