Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community
I got stuck at one point while creating Combo Chart.
Kindly see the Attachment.
Regards
Aviral Nag
Re-write the expression as:
=Sum([Normal Sales]-PercentageValue*[Gross Sales])/1000000
Check for this case:
//CHANNEL/Oce Wide Format Printer/OCE TDS400/14-Feb-14
Desired Result Net Sales - 44265
According to your expression - 132795
You need to think a bit more about what your expression is.
Normal Sales and Gross Sales are actual amounts, whereas PercentageValue is a percentage.
Therefore subtracting PercentageAmount from either of your actual amounts is meaningless.
What is your Net Sales Calculation supposed to be?
Sum(Normal Sales) - Sum(Gross Sales* PercentageValue) ?
So what should I do in this case???
I asked you a couple of questions earlier, if you can't provide answers then how is anyone supposed to help you?
Why don't you provide an example of values of Normal Sales, Gross Sales, and Percentage Value (non zero please!), and tell us what you think the result of the Net Sales Calculation should be?