on 03-24-2006 4:30 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.