Hi I have the below
The R1 gets produced but the R0 is failing.
I am attempting to say
Anything where both the status and the Aaro Booking period are null = R0
where only the the status is null = R1
all others = Status
May be try with Len(Trim())
=If(Len(Trim(Status)) = 0,
If(Len(Trim(AARO_Booking_Period)) = 0, 'R0', 'R1'), Status)
Fraid not R0 is still not getting produced, i have checked the data and there are actual cases where R0 should be.
Would you be able to share some raw data to test this out?
Retrieving data ...