February 28th, 2012, 12:36 PM #1
- Join Date
- Feb 2012
Error message after trying to add new formula
I have been trying unsuccessfully to add another year (2013) into a Benefit Credits field in Approach which is linked to a Work Card Page. I successfully added the months and year 2013 to the Work Card Page and they are calculating just fine, but unable to get 2013 Benefit Credits and Service Credits formula to enter for the new year 2013.
The # of fields is now showing 124. I make sure that the data base is the correct one. When I go to add the formula it gives me a message: UNABLE TO EVALUATE THE FORMULA SPECIFIED PLEASE DEFINE A VALID FORMULA.
Below is the formula that works just fine for the year 2012, AND ALL PREVIOUS YEARS, but the next one, (which looks exactly the same, because I copied and pasted it in the formula box after changing the year), does not. Do you have any idea why I cannot add a new formula?? Thanks, Jo Ann
("Benefit Credits Thru 2011") + If(Total12 <= 99, 0, If(Total12 <= 109, 0.625, If(Total12 <= 119, 0.6975, If(Total12 <= 129, 0.75, If(Total12 <= 139, 0.8125, If(Total12 <= 149, 0.875, If(Total12 <= 159, 0.9375, 1)))))))
("Benefit Credits Thru 2012") + If(Total13 <= 99, 0, If(Total13 <= 109, 0.625, If(Total13 <= 119, 0.6975, If(Total13 <= 129, 0.75, If(Total13 <= 139, 0.8125, If(Total13 <= 149, 0.875, If(Total13 <= 159, 0.9375, 1)))))))
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By nbabe in forum General Tech DiscussionReplies: 10Last Post: January 5th, 2008, 10:07 PM
By chadh581 in forum General Tech DiscussionReplies: 1Last Post: December 21st, 2006, 05:20 PM
By [Neo770] in forum Applications and Operating SystemsReplies: 1Last Post: September 1st, 2005, 07:27 PM
By Xorcist in forum Technical SupportReplies: 2Last Post: September 11th, 2003, 03:57 PM
By Shadowhaxor in forum Applications and Operating SystemsReplies: 7Last Post: February 13th, 2002, 05:49 PM