Hi,
In my query
select AVG(totalpaid) as 'avg cost/30 days(physican)',
from test
Now Basically in that column i am getting COST..and I want to add
$ sign before that...and also I want to restrict my o/p with only 3 Decimal.
current result
123.100129
444.237800
666.423878
Desierd o/p
$123.100
$444.237
$666.423
Thank you
I have a chart on a report that shows value in £ on the Y Axis. The values can be both positive and negative. I would like to have the negative labels to show in red and the positive in black. What is the expression syntax to achieve this? i know it will be an IIF statement, but what is the syntax to show the Y Axis label as <0?
eg if i was doing this for a field it would be iif(Field!Fieldname.value <0, "RED","BLACK") but what would i replace the FIELD!Fieldname.vaue with so the expression would change the Y Axis label.
Thanks in advance for any help
Dave Munro