Hello,
My requirment is if the Dat1 is less than current date then result is equal to quantity but if it DAT1 is blank then the result = 0
I have 2 dates as keyfigures and I need to use a CKF which is something like this
If Dat1 < currentdate.
result = qty .
ELSEIF DAT1 = blank ‘ ‘ (00/00/0000 basically blank).
Result = 0.
I did this using Boolean Operators
( DAT1 < currentdate) * Qty. And this works fine.
I just cant get to the part where IF DAT1 = blank then result =0.
I tried something like this in extension to the operators I used above.
( DAT1 < currentdate) * Qty + (DAT1 = ‘’) * ‘0’. But that didn’t work.
Please suggest your inputs and thanks in advance.
Krrish