Hi All - I am having an issue with an eSQL calculation, and it is a hum dinger.
See attached screenshots, for more clarification.
bug1 = shows the calculation not working for the record named "58"
bug2 = shows the calculation working for record "58" if i drop of the valid location line
and the dinger
bug3 = shows the calculation shown in bug1 working as required for a different record in the same table.
I have 120 records not giving me a result this calculation shown in bug3 can provide and the rest do, very strange. I am hoping I am missing something simple; I have stared at this for too long and hoping for a different perspective.