I would like to see Round, RoundUp, and RoundDown functions available in the operators in Bionic Rules Formula Fields, and also be able to apply these functions to numeric results of calculations with dates. I have a system wherein contracts are listed as multiple contiguous years, i.e.
Start Date: August 1 2012
End Date: August 1, 2018
I need to know the most recent anniversary of the account in order to know how far along they should be in an annual client lifecycle and trigger events based on that timeframe. This is far preferable to adding an OR function for every possible year increment up to our contract max length (up to 20 years). In this example the correct result of a function to calculate the most recent anniversary is August 1, 2017. The best way that I have come up with to get the correct result involves rounding down:
=Current_Contract_Start_Date__c+(365*ROUNDDOWN((TODAY()-Current_Contract_Start_Date__c)/365))
New Idea
Please add Rounding in Bionic Rules Formula Fields
If I am reading you correctly, you are trying to add "n" to the yyyy (four digit year) value.
If so, then ya I wish there was an easier way to do this. Milestones would be much simpler. I would also be able to trigger annual surveys much more easily as well.
If so, then ya I wish there was an easier way to do this. Milestones would be much simpler. I would also be able to trigger annual surveys much more easily as well.
+3Hi
Yes, giving a Round() functions in rules would be a nice idea.
If you don’t mind can you, please provide your use-case with an example of what you are trying to achieve using rules. What’s your input data and what type of Output you are expecting.
So that we can provide you an alternative way or workaround.
Thanks.
1 person likes this
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.