How to bring values in Length of Service line item?

MayurBodade
MayurBodade
in Modeling

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

image.png
image.png

Tagged:

Best Answer

  • Dikshant
    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.

Answers

  • MayurBodade
    MayurBodade

    @Dikshant Thanks. You're a Saviour!

  • RyanD
    RyanD

    @Dikshant I am somewhat confused on how to populate the line items for the module QUO05 length of service details.

    I inputted same value as the length of service list as a number format and as a text format in the respective columns, and my tenure calculation appears to be correct. However, I am unsure what the purpose of the code line item is. Could you shed some light on the purpose of this line item "Code" and whether I am on the right track? Thank you in advance.

    Screenshot 2024-06-18 at 11.34.06 PM.png

  • Dikshant
    Dikshant

    The data is redundant but the code line item is in text format and the number line item is in numeric format. For calculation purposes, only the numeric line item is needed, while the code serves as a reference. Despite the different formats, the values are identical. The formula for generating the code can be: CODE(ITEM(Length of Service))

Categories