Expression builder problem (1 Viewer)

[arage]

Hi,
In my report I have a field called ProjectedSpending, it looks like this:

=IIf([OpenPayable]=0,0,[OpenPayable]+[TotalPaid])

However when OpenPayable is not zero, then ProjectedSpending = OpenPayable, not OpenPayable+TotalPaid

Any ideas as I’ve looked and am stumped where I fouled up.
Thanks!

 

[arage]

never mind, i cleared the problem i was referencing a wrong field in my calculations, DOH!

 

[arage]

In re: to my post above, please note that ProjectedSpending looks like this now:

=IIf([OpenPayable]=0,0,[OpenPayable]+[Text93])

but this:

=Sum([Text118]) Doesn’t work in my footer where I’m trying to total the values that appear in the Text118(ie ProjectedSpending). When I run the report I’m prompted to enter a parameter value. The control is formatted as currency but only appears on the report, while the other values being totaled came from a query.

Any ideas?
Thanks!

 

[Rich]

Which footer?