[ABUSE] By: RoSmith / Board: 201 (476)

RoSmith

Hi, most post, which I desperately need help with, has been marked as spam. Please unmark it and please help. I can't progress with the 201 course until this problem is solved.

Link to post:
(Activity 17 - Rep Quota showing all zeroes)

by RoSmith

https://community.anaplan.com/t5/201-Intermediate-Model-Building/Activity-17-Rep-Quota-showing-all-zeroes/m-p/38741#M476

<p>Hello, I've worked my way through activity 17 and have come to check my results... but all the numerical values are showing zero.</p><p>&nbsp;</p><p>I've checked the forumlas against the guide and the video instructions.</p><p>&nbsp;</p><p>I've seen that when other people have had this problem, it's because they had Versions in their Roal Goals, but I don't have that. I do have it in Rep Quota. Is that this issue?</p><p>&nbsp;</p><p>With so many forumlas in this page, it's difficult to know which to ask for help for. I've attached screenshots of all the complicated ones, along with a general screenshot and the error message I get when I try to input Goal * Ramp Status for Quota.</p><p>&nbsp;</p><p>Your help would be much appreciated!</p><p>&nbsp;</p><p>[Edit:] To make it easier to read my forumlas, I have copied them below:</p><p>&nbsp;</p><p>Region: PARENT(PARENT(PARENT(ITEM('Reps L4'))))</p><p>Role: Rep Setup.Roles</p><div class="ace-line"><span class="author-6111373844">Goal: IF Active? THEN Role Goals.Quota Goal[LOOKUP: Region, LOOKUP: Role] / 12 ELSE 0</span></div><div class="ace-line"><span class="author-6111373844">Active?:IF ISBLANK(Rep Setup.Start Date) THEN FALSE ELSE IF Rep Setup.Start Date &gt; END() THEN FALSE ELSE IF ISNOTBLANK(Rep Setup.Start Date) AND Rep Setup.End Date &lt; START() THEN FALSE ELSE TRUE</span></div><div class="ace-line">Headcount:&nbsp;<span class="author-6111373844">IF Quota &gt; 0 THEN 1 ELSE 0</span></div><div class="ace-line">Tenure:&nbsp;<span class="author-6111373844">IF NOT Active? THEN 0 ELSE IF YEAR(START()) - YEAR(Rep Setup.Start Date) = 0 THEN&nbsp;MONTH(START()) - MONTH(Rep Setup.Start Date) + 1 ELSE 12 - MONTH(Rep Setup.Start Date) + Ramp Period: (YEAR(START()) - YEAR(Rep Setup.Start Date)) * 12 - (12 - MONTH(START())) + 1</span></div><div class="ace-line"><span class="author-6111373844">Text Tenure: TEXT(Tenure)</span></div><div class="ace-line"><span class="author-6111373844">Ramp Period: IF Active? THEN IF Tenure &gt; 18 THEN Ramping Periods.'18' ELSE FINDITEM(Ramping Periods, Text Tenure) ELSE BLANK</span></div><div class="ace-line"><span class="author-6111373844">Ramp: Ramping Profile.Ramp Percent[LOOKUP: Ramp Period, LOOKUP: Scenario Selection.Ramp]</span></div><div class="ace-line">Ramp Status:&nbsp;<span class="author-6111373844">Headcount * Ramp</span></div><div class="ace-line"><span class="author-6111373844">Quota: Goal * Ramp</span></div><div class="ace-line">&nbsp;</div><div class="ace-line"><span class="author-6111373844">I have tried deleting all the formulas, deleting the Switchover, and then reentering them. I'm still seeing all 0s after the first line.</span></div><div class="ace-line">&nbsp;</div><div class="ace-line"><span class="author-6111373844">I'm at a loss about what to do at this point, and I can't really move on with the course until I fix this. Help would be very much appreciated!</span></div>

This message has 0 replies