Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
There is a function called DayNumberOfQuarter... may be you need that instead of DayNumberOfYear?