Time elappsed

[mario-sarkis]

Dear All ,

I need to calculate Time Elapsed Quarterly , I am currently calculated Daily as follow :

vTimeElapsed: (((DayNumberOfYear(num(Today()) )-1)/365*100)-1 .

I want to Calculate the time elapsed in the script QUARTERLY since my score is a Quarterly score,

Some KPIs has a percentage VS Time elapsed % and are calculated quarterly.

Can you help me to calculate vTimeElapsed as Quarterly since I need to save it as quarterly

Exemple  : Q1 as end of March = 23.7% , Q2 as End of Juin...

Thank you,

hope you can help.

[sunny_talwar]

There is a function called DayNumberOfQuarter... may be you need that instead of DayNumberOfYear?