I am using an IF function to returns for TRUE a Jet (GL) function and for FALSE a SUM based upon the value in another cell. This works however when the report is run and the IF function returns FALSE it calculates the formula and returns a value. So the SUM function does not change when changes are made to the workbook in report mode.
So essentially I am looking to have the IF function return the SUM formula and not the value.
Any ideas?
Date
Votes
1 comment
-
Jet Reports Historic Posts If I understand what you are doing - you have the Jet function inside of an IF function.
I've not done this much myself, and when I have, I haven't noticed an error like you are describing.
Except when I learned that you can't put a Jet ROWS function inside of an IF statement :oops:
it may be something with the GL functions that causes it (I haven't done much with those).
But if I did have an error like this, I would probably use a helper column - so that my Jet formula could run in that column, and then use the IF statement to reference either the result of the Jet formula or the Sum from the other cell.
Something like this:
F5 = Jet formula
G5 = IF(x=y,F5,H5+3)
H5 = your other number for the sum formula
be sure to put HIDE in cell F1
NOTE - this works unless you are going to use the Jet Scheduler to remove the hidden column F, if you are going to do that, then you'll need to wrap the formula in G5 in an NP(EVAL formula
Please sign in to leave a comment.