How to bring values in Length of Service line item?

31MB · 2024-06-01T07:36:02+00:00

There was an error rendering this rich post.

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

31MB

@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

Propagate data from branches/parent lists to leaf lists
This one is not for the faint hearted lol. Functionality is to have ability to capture business policies at different levels of the hierarchy. Business policies have customer and product as dimensions. The customer/product list levels is configurable. Customer list has the following hierarchy: Country ⇒ Channel ⇒ Customer…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…