The formula field works well, but if I need to take today's date and subtract a different date field, I have to do a transform task to put in the Rule Date formula field, then do a 2nd transform task to make the magic happen. I take an existing date field and subtract today, I don't need the extra transformation task.
Ask: allow me to use Rule Date in either slot of the date diff formula.
New Idea
Expand date diff bionic rules formula
I agree that it was confusing that I couldn't use Rule Date in the first slot of the Date Diff formula field without having to add it in a previous transformation step.
I did end up using it in the second slot instead.
I did end up using it in the second slot instead.
Hello Everyone!
The Add/Subtract Date Formula field in the Date Formulas of Transformation Tasks now accepts dynamic fields. Previously, this field accepted only static numeric values as input. With this v6.16 release, the number of days you add to or subtract from a date dynamically changes with the value of the selected field.
Also, Gainsight introduces new Number Formulas to the Formula Fields in Rules Engine. These enable you to perform powerful calculations in your Transformation Tasks while setting up a rule.
This feature is implemented in both SFDC & NXT versions.
Thanks for posting!
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.