Solved

# Logic problem

Posted on 2003-12-02
171 Views

Hi Guys

I have a field AllowanceAH computed Number

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
• 2
• 2

LVL 24

Assisted Solution

HemanthaKumar earned 150 total points
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

qwaletee earned 200 total points
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

For this he has to change lots of formula code...
0

Author Comment

I used a combibation of your suggestions abit of my own and away we go
0

LVL 31

Expert Comment

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

This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
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.