Annualized Terms and Turnover
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!!
Comments

You can use beast mode:
Current Terms/
(Datediff(STR_TO_DATE(concat('01/01/',YEAR(Current_Date()))),Current_Date())/DATEDIFF(STR_TO_DATE(concat('01/01/',YEAR(Current_DATE()))), STR_TO_DATE(concat('31/12/',YEAR(Current_Date)))))
Note: I assumed that Current Terms is a field in your dataset.
Let me know if it works or not,0 
Hi Rahul,
Right now the YTD terms are being figured by using this beast mode in the data set:
Case when YEAR(`dateOfTermination`)= YEAR(CURRENT_DATE()) then 1 Else 0
EndWhat would be the best way to input that into the formula you gave me?
Thank you!
Becki
0 
Hey Becki,
I am not sure what you mean by YTD terms if its Current Terms then the formula could possibly be:
SUM(Case when YEAR(`dateOfTermination`)= YEAR(CURRENT_DATE()) then 1 Else 0
End)/
(Datediff(STR_TO_DATE(concat('01/01/',YEAR(Current_Date()))),Current_Date())/DATEDIFF(STR_TO_DATE(concat('01/01/',YEAR(Current_DATE()))), STR_TO_DATE(concat('31/12/',YEAR(Current_Date)))))I am not sure if this will work or not. Please let me know,
0 
Hi there,
Hmm it didn't work. I'm not sure what would be helpful for you to see. Here's a snap shot of the top of the card, and the beast mode that's calculating the second column as a sum for the total YTD terms.
0
Categories
 10.6K All Categories
 APAC User Group
 12 Welcome
 36 Domo News
 9.6K Using Domo
 1.9K Dataflows
 2.4K Card Building
 2.2K Ideas Exchange
 1.2K Connectors
 339 Workbench
 251 Domo Best Practices
 11 Domo Certification
 461 Domo Developer
 47 Domo Everywhere
 100 Apps
 703 New to Domo
 84 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 22 お知らせ
 62 Kowaza
 296 仲間に相談
 649 ひらめき共有