Totaling a calculated field
Posted on 2011-10-24
I have a report which I have added the following calculated field in the detail section.
IIf([Awarded]=True,[Est Revenue],0) (This field is [Text43])
This field calculates correctly.
I am now in the report footer trying to sum this field.
are both asking for the values of [Text43]
Doesn't test for true, it brings back a sum of all records.
Thoughts on how to format this sum?
Also, an additonal 100 points if someone can tell me how to format my calculated field [Text43] to Currency. Setting the format to Currentcy in the control property doesn't work.