Skip to Content
0
Former Member
Nov 02, 2012 at 06:30 PM

Formula for CKF on Dates

47 Views

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