About davraes

Hello- We have two modules one for planning miscellaneous revenue and other for planning for OTPS. When a user enters an amount in the FY21 column the amount is not spreading evening for the forecast period. The forecast period is 6 months. Please see the attachment. I am not sure what I need to do to fix this.  ... View more

I am trying to build a formula to pull in fringe benefit rates based on the department/unit and employee works for. I attempted to build an IF Then formula but Anaplan keeps telling me it is invalid. See my formula below.   IF Dept Code >= 0000 and Dept Code <= 5999 OR Dept Code = 6500 OR >= 7000 and Dept Code <=7199 THEN UPG Admin FB Rates.Fringe Rate[LOOKUP: Staff Types (UPG)] OR IF Dept Code >= 6000 and Dept Code <= 6999 THEN UPG CPG Fringe Rates.Fringe Rates[LOOKUP: Staff Types (UPG)] OR IF Dept Code >= 8700 and Dept Code <= 8799 THEN UPG RPCN Fringe Rates.Fringe Rate[LOOKUP: Staff Types (UPG)] OR IF Dept Code >= 8000 and Dept Code <= 8600 THEN UPG RPCS Fringe Rates.Fringe Rate[LOOKUP: Staff Types(UPG)] OR ELSE 0   Any assistance is appreciated. Thanks, Davrae ... View more

I need help with section 13. My numbers do not look correct. Activity 12 , I was able to verify the totals in the exercise guide. See my formulas and calculations.  ... View more