Printable View
I need to know how to format a simple addition problem:
{@4}+{@5}+{@6}+{@7}
I want to add the totals of these formulas:
If {PAYABLES_TRANSACTION.Starting4} < CurrentDate And {PAYABLES_TRANSACTION.Ending4} > CurrentDate Then
"$" & {PAYABLES_TRANSACTION.Amount4}
Help I cannot get a seemingly simple function to work.
It seems to me that the formulas are returning strings. Are the Amount fields strings? If no, why are the formulas returning strings (because of the "$" & {PAYABLES_TRANSACTION.Amount4} statement).
Don't format data within the formula, use the Format Editor. The formula would then return a number which can be used in mathematical equations.
I have changed the formatting, and I made sure the fields I need to add are numeric in the database. But my addition field will not add. All I am writing is
Why won't this simple equation work? What step am I missing?VB Code:
Can you post the RPT file?
I think the RPT document is attached.
The faulty addition code is in the formatAmount formula.
Thanks!
Sorry, I only have version 8.5 of Crystal and cannot open the report file. Is it possible to save the report as a version 8.5 file?
I didn't see an option for any other version of Crystal.
I had a quick look at your report and it seems that the formula should work.
One thing I noticed was that you had 'Save Data with Report' checked, maybe that's part of the problem.
Under File|Report Options you could try checking Convert Database NULL Values to Default and Convert Other NULL Values to Default. Crystal's not too smart sometimes when it comes to handling NULLs and I've seen it do some wierd stuff when it finds a Null in your data.
Worth a shot...