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!

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Nya 29,060 on at

Like (1)

Report

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

Was this reply helpful? Yes No