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
 11.3K All Categories
 6 Private Company Board
 2 APAC User Group
 12 Welcome
 45 Domo News
 10.2K Using Domo
 2K Dataflows
 2.6K Card Building
 2.3K Ideas Exchange
 1.3K Connectors
 354 Workbench
 271 Domo Best Practices
 13 Domo Certification
 482 Domo Developer
 58 Domo Everywhere
 113 Apps
 734 New to Domo
 86 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 31 お知らせ
 65 Kowaza
 305 仲間に相談
 667 ひらめき共有