Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a IF expression like IF(condition a AND condition b AND condition c AND condition d AND condition e, reportId,'N/A').
In condition I am comparing a variable with a column like
condition a 😆 createDate >= CalenderDate(column from one of my table)
condition b 😆 createDate <= CalenderDate(column from one of my table)
What I observed that rows having createDate is NULL in database but satisfying the condition c,d,e are displaying in my result. My assumption for logical expression is NULL >= CalenderDate will return FALSE and therefore the whole expression will return FALSE adn finally the IF expression should display 'N/A'.
It should operate internally like
IF(FALSE AND TRUE AND TRUE AND TRUE AND TRUE,reportId,'N/A') => If(FASLE,reportId,'N/A') => N/A
I tried to reproduce what you've observed but failed to do so.
Maybe you could check my attached sample and update to your setting or create your own sample?
BTW, on what version are you? I checked QV9 and 11.
Regards,
Stefan