Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
i need to calculate only discount value from total sales value.
i am not getting how to write expression.
Thank You.
Hi prachi
plz provide some sample data
Hi Prachi,
Formula May be like this:
Sum(Sales)*Discount Percenteage/100
So Suppose Your Sales =100,
Discount Percentage= 10%
100*10/100=10
Thanks,
Arvind Patil
Sales | Quantity | Discount | Profit | Shipping Cost |
2309.65 | 7 | 0% | 762.1845 | 933.57 |
3709.395 | 9 | 10% | -288.765 | 923.63 |
5175.171 | 9 | 10% | 919.971 | 915.49 |
2892.51 | 5 | 10% | -96.54 | 910.16 |
2832.96 | 8 | 0% | 311.52 | 903.04 |
2862.675 | 5 | 10% | 763.275 | 897.35 |
I need to calculate discount value(for eg. second row sales value is 3709.395 and discount 10% so want to find discount value)
i have different discount like
I think this is fine
=Sum(Sales * Discount)
Please try with this
SUM(SALES)*SUM(DISCOUNT)
Hi,
I think your willl the issue is with the discount field, if it shows as 10% it will be dealing with it as a string.
Either in Script add
NUM(PURGECHAR(Discount,'%')) AS DiscountNum
Or in the set analysis
SUM(Sale*NUM(PURGECHAR(Discount,'%')))
Mark