Rebuilding lifecycle weeks per year field in NXT

  • 16 November 2019
  • 3 replies


In the SFDC version of Gainsight, there are a few lifecycle formula fields that come standard on the customer info object. One particular useful one is called Life cycle weeks per year. This does not exist in NXT: 


Use case: This field takes a customer’s start date and calculates how many weeks today is from that date, but evaluates on a relative 52 week timeline vs absolute. For example: If the customer’s start date is 11/1/18 and today is 11/8/19, this field would return 1 week vs 53 weeks. This is extremely helpful for building automated lifecycle management programs, because you can add customers to programs based on lifecycle weeks vs anchoring on a renewal date or a calendar year. 


With this field, you can build programs to send to customers every Q1 and Q3 based on their start date vs. a renewal date or calendar date. Without this field, you have to either work off renewal date (tricky because of annual contracts and multi-year contacts and because renewal dates can change based on contracts) or you have to hard code in a lot of fitlers. Example: Lifecycle Q1 translates to Week 0 - Week 12 OR Week 52 - week 64 and so on (based on today - customer start date).



Issue: I can’t recreate this field because rules engine and calculated field formulas do not include the function floor or ceiling aka roundup or rounddown. It turns out that the rounding function is cruical to make this formula work as intended. 


Has anybody successfully created these fields in NXT? If not, are there other ways to get the same functionality? 

3 replies

+1 To this thread. Anyone figure out how we can keep track of this in NXT?


Badge +3

I found this question after realizing the rule we had for this was not working correctly from our NXT migration.

It took me 5 transform steps to build all the fields needed (perhaps someone else can shorten it), but here is how we have it set up:


New Horizon rules, reference object = Company

We have “original contract date” synced from SFDC that serves as starting date for an account.


Transform 1, new formula field:


Transform 2, new formula field:


Transform 3, new formula field:


Transform 4, new formula field:


Transform 5, new formula field: 



Then use a Load to Company action to map Ceiling Weeks to the Lifecycle Weeks field.