*For your reference I am using the NL functions and NOT Table Builder*
I am working on a formula that should allow me to say IF a Order Flow ($H15) = for example (OI LCL 0000). I would like column ($I15) to = (LCL). Because this is information coming out of a database, NL(Rows) is being used to pull all records based on my filters.
I tried the following scenarios in column $I15:
NP("Eval")
=NP("Eval";"=IF(MID($H15;4;3)=""LCL"";""LCL"";"""")
This gave me the correct result. However, the rows below contained the same result due to EVAL function which breaks the connection to the database.
NP("Formula")
When I use this function and run the report, it just gives me the result of
Formula(IF= etc............)
I could just use the =IF formula which gives me the correct result but after I run the report I don't want the formula to be seen in the formula bar as well.
What am I not doing correctly for it to for the formula function to not work correctly? It would be appreciated if you van provide me with some examples so I can see where I am going wrong.
