Formula Does not Calculate

[fsub]

Just wanted to share this....

I have this simple formula to add a few variables. VarB := VarC + VarE + VarI + VarJ + VarK;. The formula does not work at times and result comes out zero.

What fixed this issue is I deleted the formula and retyped everything. And it worked. My guess is that the formula contained some undisplayed character that the syntax checker does not catch.

 

[Madawc]

I've had similar: the software makes assumptions it does not tell you about.

Incidentally, you could have done it more conveniently as

VarC + VarE + VarI + VarJ + VarK

Suitable also to place at detail-line level and summarise. If you're not already familiar with Crystal's automated totals, see FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP