Error in Formula in Rep quota module

Hi , Can any one please help me with the following formulas used in Rep Quota Moduel: Tenure Formula: IF NOT Active? THEN 0 ELSE IF YEAR(START()) ‐ YEAR(REPSETUP.Start Date) = 0 THEN MONTH(START()) ‐ MONTH(REPSETUP.Start Date) + 1 ELSE 12 ‐ MONTH(REP SETUP.Start Date) + (YEAR(START()) ‐ YEAR(REP SETUP.Start Date)) * 12‐ (12 ‐ MONTH(START())) + 1 Ramp Period : IF Active? THEN IF Tenure > 18 THEN Ramping Periods.'18' ELSE FINDITEM(Ramping Periods, Text Tenure) ELSE BLANK iam using the above mentioned formulas and getting an error message.

Accepted answers

PrevContributor

[quote=Pavan Bellemkonda]Tenure Formula:
IF NOT Active? THEN 0 ELSE IF YEAR(START()) ‐ YEAR(REPSETUP.Start Date) = 0 THEN MONTH(START()) ‐ MONTH(REPSETUP.Start Date) + 1 ELSE 12 ‐ MONTH(REP SETUP.Start Date) + (YEAR(START()) ‐ YEAR(REP
SETUP.Start Date)) * 12‐ (12 ‐ MONTH(START())) + 1

Ramp Period :
IF Active? THEN IF Tenure > 18 THEN
Ramping Periods.'18' ELSE
FINDITEM(Ramping Periods, Text
Tenure) ELSE BLANK[/quote]The error might just be because 'Active?' needs to be in single quotes because it contains a question mark.

PrevContributor

Some questions then:
Are both formulas giving you error messages? Or is only one of the formulas giving you an error?
The first formula, for Tenure, looks fine to me. If that is erroring, can you check the dimensionality and formatting of 'REPSETUP.StartDate' - based on this, it should have all the same dimensions and be formatted as a date.

Is there any information in the error message?

What lists do you have applying to each of the line items where you are putting these formulas?

The Ramp Period formula also looks fine. If you delete the formula from Tenure, does the Ramp Period formula work? Is the Ramp Period line item formatted using the Ramping Periods list?

All comments

PrevContributor

Hi Amy,
i have used the single quotes but It still gives me the same error

PrevContributor

Hi Amy,
I delated the module and made a new one . Now all formulas are working fine .
Thanks

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385