Jump to content

problem with multiple values (calculation)


This topic is 7215 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I have following fields in my database : [Price], [Price1], [Price2], [Price3], [Price4] and [Qty].

Here is my problem:

If [Qty] is between 1 and 19, [Price] should display value from [Price1].

If [Qty] is between 20 and 40, [Price] should display value from [Price2]...etc.

Sounds easy, but my mind is empty after too many attempts.

Please help.

Link to comment
Share on other sites

  • Newbies

ALL RIGHT ,

It really did help.

I changed "," to ";" , like this:

Case(

Qty <= 19; Price1;

Qty >= 20 and Qty <= 40; Price2;

Qty >= 21 and Qty <= 50; Price3;

Qty >= 51 ; Price4;

"")

Now it works just fine!

Thank You

regards

Juha

Link to comment
Share on other sites

Hi Juha,

I didn't know you were using a Non-US version. Why not update your profile to reflect you location and some of the other blank info. It can help us be more accurate with our answers.

Lee

p.s. Glad you got it working.

wink.gif

Link to comment
Share on other sites

This topic is 7215 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.