Solved

Logic problem

Posted on 2003-12-02
5
171 Views
Last Modified: 2013-12-18


Hi Guys

 I have a field AllowanceAH computed Number

AllowanceCalc := @If(CountryAH ="Canada";CanHolAH;
                                                                          CountryAH= "United Kingdom";BritHolAH;
                                                                                                                                         CountryAH= "United States";USHolAH; "");

@If(CountryAH ="";0; CountryAH !="";AllowanceCalc ;AllowanceAH)

I need to be able to overide the values set by AllowaanceCalc

When I change them they reset

Same with this one
@If(CountryAH ="";0 ;CountryAH = "Canada":"United States";5;PersonalDays
0
Comment
Question by:adspmo
  • 2
  • 2
5 Comments
 
LVL 24

Assisted Solution

by:HemanthaKumar
HemanthaKumar earned 150 total points
Comment Utility
Create agent to set the values like this

FIELD AllocanceAH = @TextToNumber(@prompt([okcanceledit]; "Title"; "Prompt"; "OverrideValue"));
""

But if the user opens the document and edits and resaves the document the computation will take over

~Hemanth
0
 
LVL 31

Accepted Solution

by:
qwaletee earned 200 total points
Comment Utility
Make three fields:
AllowanceCalcDefault -- replaces current AllowanceCalc (same field setup and formula)
AllowanceCalcOverride -- editable number
AllowanceCalc -- new field with the following formula:
@If(@IsError(AllowanceCalcOverride*1);AllowanceCalcDefault;AllowanceCalcOverride)

That's it!  Now, if user leavs AllowanceCalcOverride, it uses the default calculation. If teh user puts in a valid number in the override field, then that value wll be used instead.
0
 
LVL 24

Expert Comment

by:HemanthaKumar
Comment Utility
For this he has to change lots of formula code...
0
 

Author Comment

by:adspmo
Comment Utility
I used a combibation of your suggestions abit of my own and away we go
0
 
LVL 31

Expert Comment

by:qwaletee
Comment Utility
HemanthaKumar,
> For this he has to change lots of formula code...
Not really.  Just exactly what I specified... a field rename, a no-formula edit field, and a new field with the old name with the specified formula.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now