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

Accepted answers

Dikshant

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.

All comments

Dikshant

MayurBodade

@Dikshant Thanks. You're a Saviour!

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

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))

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…