Link to home
Start Free TrialLog in
Avatar of Shine56
Shine56Flag for Canada

asked on

Case Structure and a Text Box

Help!

I am working with a form that retrieves a value using a case structure;

Case(
fuel_consumption="low" and rate_based_on ="One Month" ;monthly_charge_out_rate_1_low;  
fuel_consumption="med" and rate_based_on ="One Month";monthly_charge_out_rate_1_med;
fuel_consumption="high" and rate_based_on ="One Month";monthly_charge_out_rate_1_high)

Now according to which ever radio box is selected, Low, Medium, High, fuel_consumption value is changed. The problem is the only value that shows is the high value. Should I be using something like GetField to retrieve the value at the end and why isn't my text box receiving the evaluated case calculation?

Thank you!

Kevin
Avatar of Member_2_908359
Member_2_908359
Flag of France image

First, if only high works, it means there is probably a spelling error, or a trailing space in the radio box choices.
Second, if the result does not turn up in yr resulting text box, then the calculation is nto triggered when expected I guess?
Is this controlled by a script?
Used in an auto-enter field?
Used in a calculated field?
Avatar of billmercer
billmercer

You may also want to check the data types of the fields involved, make sure you're not mixing number and text values.
Also might want to make sure the calc solution is unstored...
ASKER CERTIFIED SOLUTION
Avatar of Member_2_908359
Member_2_908359
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
And who said that the points will be refunded?
nobody; you suggested it! so I guess you'll do it if nobody complains. and you know my point of view, I already wrote it in other threads.
It is not for me, I absolutely don't care, I am here for fun, but I think it is not fair to abandon questions, and therefore I think EE can claim to keep the points.
>>you suggested it!
Had I? Read a few comments above and what it is? -"Delete - no points refunded" I thought that the word 'NO' is clear.

I know it is easier to start posting without reading but... :) In such question the recommendation can never be a refund :)

Avatar of Shine56

ASKER

Guys,

Calm down. No fighting just because I haven't checked my e-mail in almost a month. I was in the hospital for reasons I won't discuss. To the admin, do I still have time to award points? lesouef did point me in the right direction, so I would like to give him the points before this topic is destroyed with fighting. Please advise and I will take care of it. Sorry for any inconvience this has caused anyone. Have a great day!

Kevin
Kevin,

Sure. JUst accept his answer :) (There is a button "Accept" next to his comment)
venabili,
sorry, I did read it, but for some reason, the NO espaced my mind, this is called reading too quickly!

shine56,
sorry for yr hospital period, EE has no way to guess and there are about 30% of questions left over, quite disppointing for support people who work here for free, our sole compensation is to know people get their pbs fixed on our recommantions.