I have the following integer fields
TotalAttend,Member,NonMem,Child,General,Coupons
I have the following formula, for which I have confirmed all of the variables are numbers:
«Cash»=(fgMem*«Member»)+(fgNon*«NonMem»);+(fgChild*«Child»)+(fgGen*«General»);-((fgMem*MemRef)+(fgNon*NonRef)+(fgChild*ChildRef))
I get an error message “Cannot Multiply Text By Number”
I also have the formula in which Member=36 NonMem=12, Coupon=5, Child=0, General=0
«TotalAttend»=«Member»+«NonMem»+«Child»+«General»+«Coupons»
Which produces the result 3612005
I’ve tried putting the second formula in the TotalAttend data sheet formula and get the same results.
Haven’t tried using val( as it seems it should not be necessary.
Do I need to go to floating point?
[tried indenting the formulas, but it wouldn’t take]