Try a calculated dimension, like
But it's funny that this is not done correctly by QV.
Is your price correctly read in as number?
(If above works, I would probably use similar expression in the load rather than using a calculated dimension).
If your Price is not correctly read in as a number (maybe you have a $ in front of it?, use num#() funtion to parse it in during load).
Thank you for your response. I tried it, and it does work. Not sure why it is not being read in as a number.
I am not sure what you mean when you say use the num#() funciton during the load.....what would the syntax be for that?
The problem is that I also have several other dimensions that are not displaying correctly. For example, the Quantity field is displaying as 1.00000000000000000000000000000000000000000000000000000000 as well.
Again, thank you!
Actually as Stefan has suggested it should work. I would only change that a little to read:
=num(sum(Price),'$#,###.00'). This will first evalute the sum and then add the thousand separator, affix the $ sign in front and add '.00' at the end.
If you wish to also show cents then use this: =num(sum(Price),'$#,###.##')