on 09-08-2016 9:34 AM
Morning Experts.
I hope someone can resolve a issue i am facing.
Basically i have two dates "Document Date" and "Due Date"
I want to see the different in days between the dates.
I inserted a column using the "New Cells"function and inserted the excel function =DatedIF(Cell,Cell,"D") function which works perfectly fine in excel 2016, but when i use it as part of the BO workbook it comes up with NA
Am i doing something wrong?
Thanks in advance
Rob
In 2.3 it returns numbers for me. I don't think this is what you want. See below:
It maybe something to add to Idea Place? SAP BusinessObjects Analysis edition for MS Office: Home - I don't see an existing suggestion out there. If you submit an idea, link back here and I will vote for it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Robbert,
I tested in 2.2 as well... it fails even with the simplest formula e.g. =D2-C2
For half a second it displays the correct difference, e.g. 5,00 (days), but then it switches to NA.
I have no idea why AO does that, either
I just guess that the problem is the leading ' e.g. '08/30/2016
Even the Excel Standard filter is not able to group dates like this into e.g.
2016
July
01... to 31 etc.
This is quite an old bug, and I think still valid, since the idea is open until today:
https://scn.sap.com/thread/3603537
BR, Martin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
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.