Good Morning,
We have a turnover card that currently shows the YTD Turnover % along with the YTD terminations.
When calculating the annualized projected terms and turnover, I have used the YEARFRAC calculation in Excel. I'm not sure what I will need to do to recreate that column here in Domo.
Here's an example of the formula I would use in Excel to get the Annualized Projections:
Current Terms: 64
Today's Date: 5/17/18
Start of Year(1/1/18)
YEAR FRAC(Start of Year, Today's Date) {would return, .37777)
So to get the annualized terms I would take 64/.37777 {would return 169.411}
Current Terms/(YearFrac(StartofYear,TodaysDate,))
Thanks in advance for help!!