Jump to content

Calculation Help


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

Recommended Posts

Sorry, but how can a cost be <25 and >50 at the same time? wink.gif

Give this a try.

Case(

Cost <= 25, Cost * 2,

Cost <= 50, Cost + 30

Cost <= 100, Cost + 50

Cost <= 200, Cost + 75,

100)

The last value is a default, if none of the tests succeed. The Case statement performs the tests in order, so an "and" criteria is not needed.

-bd (engineering major)

Link to comment
Share on other sites

  • Newbies

I need some help with a calculation. I have six price points that I need to have a set mark-up applied to. I need to look at the entry in the cost field and then apply the apropriate mark-up. For example, if an item costs from $0 to $25, then it needs to X2, if it is between 26 and 50, it needs to add $30.00 ad so on.

Problem is, I was a communciation major and english minor and do not understand the whole if..then math logic. Any help would be appreciated.

John

Link to comment
Share on other sites

Try a Case statement calculated field:

Case(Cost >= 25, Cost + 25,

Cost < 25 and Cost > 50, Cost + 30, Default value)

You can run this as many times as needs to cover the different parameters. The default value would be some value that would be used if all of the cases failed.

HTH

Link to comment
Share on other sites

This topic is 8546 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.