How to bring values in Length of Service line item?


Hi All,

I am really struggling to bring values in the Length of Service line item. Since the module is not big I had first tried to manually select items from drop down for all Reps but I realized that it is not the best way. Can anybody please suggest something?

Here are my model Normal View and Blueprint view

Best Answer

  • Dikshant
    Answer ✓

    I will give you some hints here. You have to calculate the length of service based on the start date. I can see you have already calculated Completed years. Use that to calculate length of Service. Use FINDITEM function to convert text format Completed Years - Text to Length of Service List format.