Skip to Content
author's profile photo Former Member
Former Member

Bex report - dates subtraction

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 24, 2006 at 04:35 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 24, 2006 at 07:06 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.