Any ideas on why the Eval Formula below may not be working corectly? The excel equivalent works. TIA
Excel Looks Like This
=IF(OR(J4<K4,AND(J4<=TODAY(),I4>0)),1,0)
Eval Looks Like This
=NP("Eval","=IF(OR("""&J4&"""<"""&K4&""",AND("""&J4&"""<=TODAY(),"""&I4&""">0)),1,0)")
Hello Todd -
How about this?
=NP("Eval","=IF(OR("""&J4&"""<"""&K4&""",AND("""&J4&"""<="""&TODAY()&""","""&I4&""">0)),1,0)")
I usually put my EVAL at the end, rather than wrapping it into the formula - it does the same thing, and for me is easier to read.
=IF(OR(J4<K4,AND(J4<=TODAY(),I4>0)),1,0)&NP("EVAL","=""""")
Basically, I'm asking it to evaluate a blank.
NOTE: there are a total of 5 " marks that follow the equals sign.
I will try both. Thanks
The EVAL at the end works well when the report is ran locally. This question is really spawned from when the report is ran from the jet server as a scheduled job it opens and starts re-calculating. Even with Auto+Hide+Values
Interesting, I do not have that issue with our setup - however, I am dealing with an environment that has only two designers
Also, most of our output is scheduled as Values Only reports, removing all Jet formulas for final output to a client.
I will make note that the EVAL may need to be embedded for it to work well in other situations.