Sage 100

Is there a way to have conditional formatting on Visual Integrator against a null field? IE: NULL(Temp005$) or Temp005$=NULL I tried both of those and got syntax errors on both

I believe I've used =

I can't get that to work in my job, it doesn't error out, but it doesn't return the results I want either. I will keep working on it.

Maybe store the conditional value in a Temp field? Are you currently trying that conditional formula on the actual data field?

No it's on a temp field, I am trying to get it to ""remember"" the field above it. I ran into this issue before, but the problem with this one vs the other is this is a null field vs a blank field, so it is remembering the null value. I am thinking this is just a bug since it's not working the way it is supposed to. I will probably just have them modify the csv file. Seems to be the only way around it.

The syntax is NUL(TEMP005$) not NULL(TEMP005$).

Thanks @DougHiggs I will try that!

@MichelleBennion - Did you get this resolved...

@JeffSchwenk , @RobertWood is looking into some perform logic he had on a previous job to see if it can be modified for mine. I will report back... however I Am open to suggestions if you have any.

Is this on an import or export?

Import, I still have the solution you gave me last time @MarkKotyla , but it's not working on this one...

Please refresh my memory Michelle.

We added a temp field (6) that populated with temp field (4) conditional on the temp field 4 being <> """" (see attached)

NUL(Temp005$) would return a result code of 1 if true or 0 if false, so... how about NUL(Temp005$)=1 as the conditional? If the field you're testing is a string, then you may have to try putting the 1 in double quotes.

No luck :( I think we have a pretty good work around, but keep this one in the back of your mind. I am sure this is not the last time this will pop up.