?
Solved

Logic problem

Posted on 2003-12-02
5
Medium Priority
?
177 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 24

Assisted Solution

by:HemanthaKumar
HemanthaKumar earned 600 total points
ID: 9859704
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 800 total points
ID: 9859782
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
ID: 9859821
For this he has to change lots of formula code...
0
 

Author Comment

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

Expert Comment

by:qwaletee
ID: 9861580
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

765 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