cancel
Showing results for 
Search instead for 
Did you mean: 

Calculated KF issue

Former Member
0 Kudos
43

Hello experts,

I have created a CKF which is giving me this result for all lines: -2.345678901E+298 .

I created formula variable for both dates and changed to display 0 as number of decimals. See below CKF:

DATE ( 'Posting date' ) - DATE ( 'Requisition date' )

Please can someone tell me what is wrong with it and also what could be my alternative to subtract to dates?

Thanks for your help.

Cesar

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Directly use as 'Posting Date' - 'Requisition Date'.

Direct subtracting works in ABAP routines.

Guess it will work in the BEx formula variable too.

cheers,

Vishvesh

Former Member
0 Kudos

I am using Date as the dimension for variable formula dates.

Thanks, Cesar

Answers (1)

Answers (1)

Former Member
0 Kudos

Cesar:

When you created your formula variables with replacement path, make sure you choose "Date" as the dimension. I believe you selected as Number as the dimension.