Discount Lists that apply to only the begin and end quantities

(0) Share

Report

Posted on by Community Member

I have the below set up in discount lists.

	Licenses up to	25	500	5,000	5,001
Month-to-month	Per User License	$ 49.00	$ 7.50	$ 1.50	Custom

All looks well, however when I select a quantity of 600, the discount is applied to all 600 licenses, which is not correct as per our business processes. I would like it to calculate as per the below.

For a system with 600 users, monthly price is ((25 * $49.00) + (475 * $7.50) + (100 * $1.50)).

Is there any way to do this with discount lists? Apply the discount only to certain amounts?

Thanks!

All responses (1)

Answers (0)

Suggested answer

Nya 29,064 on at

Like (1)

Report
Copy link

Link copied!

Hi,

It is recommended to create a custom field as Amount whose Field Type is Calculated.

Set the number of licenses as the condition of the calculation.

For example, the number = 600, the amount can be calculated as:

If number ≤ 25,

Amount = number * $49.00,

If number > 25 and number ≤ 500,

Amount = 25 * $49.00 + (number-25) * $7.50,

If number > 500 and number ≤ 5000,

Amount = 25 * $49.00 + 475 * $7.50 + (number-500) * $1.50,

If number > 5000,

Amount = 25 * $49.00 + 475 * $7.50 + 4500 * $1.50 + (number-5000) * Custom.

If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.

Best Regards,

Nya