Skip to Content
Jan 10, 2020 at 11:26 PM

Formula with dates

82 Views Last edit Jan 13, 2020 at 02:48 AM 2 rev

Dear Experts,

Long time no talk ! Happy new year 2020 !

Enough with formalities :-) Let's get straight to the point

I'm trying to build a key figure that would give me the number of outstanding days a transaction has not been invoiced.

So, I adapted the data source to get the provisioning date as a key figure. I created a new key figure using this formula :

[Today] - [Provisioning Date], no exceptional aggegrated

But the result I get is incorrect, 737 435 for all dates...Not too sure what it represents :)

Is it something that what I am missing or is there alternative way to achieve this calculation ?

Thanks for your future help !