cancel
Showing results for 
Search instead for 
Did you mean: 

Insert Excel Formula Function Analysis 2.2

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

TammyPowlas
Active Contributor
0 Kudos

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.

Answers (1)

Answers (1)

Former Member
0 Kudos

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