Jump to content

Price Range Help


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

Recommended Posts

Hi,

I want to attribute a Price Group to each of my Products in a 50,000 Product.fp5 records list.

The Range of each Group is already established in a PriceGroup.fp5 file.

Each products price is already rounded at the nearest quarter, but the PriceGroup isn't.

I want 12,50$ to match Group 5 with Multikey values of 10,11,12,13,14,15.

crazy.gif

OK....I keep the post here... blush.gif

I can't believe it happened again, as was noticed by another fellow here. Found the answer while posting it, after a 2 hours struggle.

smile.gif

Round the calc with Round(Price,0) and makes it relate to the Multikey in the PriceGroup.

Now, I'm still open for better solutions...except calculations (that was used at first place - Case statement that needed to be changed anytime a Group was changing).

Thanks, and good w.e.

Link to comment
Share on other sites

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