Hi there - I know this should be simple but I cannot figure it out!
I'm am trying to do a simple if statement where it looks at line 1 and then next row and if the ref is the same but the month fields is different then highlight this fact by updating column x for example
I am trying to use a Multi-Row
using the code
IF [Sysref]=[Row+1:SysRef] and [DateTime_Out2]=[Row+1:DateTime_Out2]then "Ok"
else "NotOk"
endif
Which returns all the ok ones which is correct - but how do I isolate all of the records where the Ref is the same but them month is different ? I cannot seem to figure out nested ifs...
So what I want:
If ref1 = ref2 then
if month1 = month2 then
"Ok"
elseif month1 not equal to month2 (but ref1 is equal to ref2)
"Not Ok"
endif
end if
Am I making sense ?
Thanks
Daniel