cancel
Showing results for 
Search instead for 
Did you mean: 

Bex report - dates subtraction

Former Member
0 Kudos

Hi,

I need to do a subtraction between 2 dates (posting date - document date) but posting date can be blank. I have created a calculated KF and a restricted KF(using the calc KF and posting <> #). My issue has to do with the result. I am getting -2.345678901E+298 value for all lines. Also I have changed to display 0 as number of decimals. Please can someone tell me how I could fix it or give to me another way to do it?

See below the calc KF:

NODIM ( DATE ( 'Posting date' ) - DATE ( 'document date' ) )

Thanks a lot.

Cesar

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

I think this issue is related to the calculated KF. i have created formula variables for the dates and added them into a CKF. The result from this CKF always comes -2.345678901E+298. Please let me know how I can remove this error or another alternative. And changed to display 0 as number of decimals. See below my CKF:

NODIM ( DATE ( 'Posting date' ) - DATE ( 'document date' ) )

Thanks.

0 Kudos

hi,

try with create formula variable with 'replacement path', right click 'keyfigures' on column area and 'new formula', in next screen, right click 'formula variable' and 'new', give variable name and description, choose type 'replacement path' and choose posting date characteristics, do the same for document date, then drag these 2 created formula variables to 'formula' area, and give - .

hope this helps.

Former Member
0 Kudos

AHP,

I have done it. My issue is that posting date can be blank. How can i created a formula doing the subtraction only if posting date is supplied?

Thanks.

Cesar

Former Member
0 Kudos

Hi,

try using a condition where you can try to block blank values.