Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I would like count the number of records with a total amount of the following fields, which contain numeric characters, being less than 0, in a set analysis:
BUILD_MSUMINSD
PLANT_SUMINSD
i.e. if(sum(BUILD_MSUMINSD, PLANT_SUMINSD)<0). So how to write "if the sum of BUILD_MSUMINSD plus PLANT_SUMINSD < 0, using an if statement please.
Many thanks
if(Rangesum(BUILD_MSUMINSD, PLANT_SUMINSD)<0)
if(Rangesum(BUILD_MSUMINSD, PLANT_SUMINSD)<0)
Thank you Anil! It works!