How discount values are calculated and fetched in saved searches and reports

If the discount amount is in Currency format:

To calculate the amount of discount that each item receives, we can follow these steps:

1. Calculate the total value of the order before any discounts are applied.
2. For each item on the order, calculate the weight of the item as a proportion of the total value of the order.
3. For each item on the order, calculate the adjusted discount amount as a proportion of the fixed discount amount of 6.00, using the weight of the item calculated in step 2.
4. Subtract the adjusted discount amount calculated in step 3 from the price of each item to get the final amount for each item.

Using your example data, here are the calculations:

1. Total value of the order = (1 * 20) + (1 * 29) + (10 * 79.99) = 848.90
2. Weight of Item 1 = 20 / 848.90 = 0.023585
   Weight of Item 2 = 29 / 848.90 = 0.034119
   Weight of Item 3 = (10 * 79.99) / 848.90 = 0.942296
3. Adjusted discount amount for Item 1 = 6.00 * 0.023585 = 0.141509
   Adjusted discount amount for Item 2 = 6.00 * 0.034119 = 0.205312
   Adjusted discount amount for Item 3 = 6.00 * 0.942296 = 5.653777
4. Final amount for Item 1 = 20 – 0.141509 = 19.858491
   Final amount for Item 2 = 29 – 0.205312 = 28.794688
   Final amount for Item 3 = (10 * 79.99) – 5.653777 = 794.236223

Again, the values above may differ slightly from what you see in your saved search due to rounding or formatting differences, but the overall calculation process should be the same.

If the discount amount is in % format:

To calculate the amount of discount that each item receives, we can follow these steps:

1. For each item on the order, calculate the discount amount by multiplying the fixed discount rate of 6% and the amount of the item.
2. Subtract the discount amount from the amount of each item to get the final amount for each item.

Using your example data, here are the calculations:

1. The discount amount for Item 1 = 6% * 20 = 1.2
   The discount amount for Item 2 = 6% * 29 = 1.74
   The discount amount for Item 3 = 6% * 799.9 = 47.994
2. Final amount for Item 1 = 20 – 1.2 = 18.8
   Final amount for Item 2 = 29 – 1.74 = 27.26
   Final amount for Item 3 = (10 * 79.99) – 47.99 = 751.90