Chart Issue - Strange Behaviour

[aveeeeeee7en]

Hi Community

I got stuck at one point while creating Combo Chart.

Kindly see the Attachment.

Regards

Aviral Nag

[tresesco]

Re-write the expression as:

=Sum([Normal Sales]-PercentageValue*[Gross Sales])/1000000

[aveeeeeee7en]

Check for this case:

//CHANNEL/Oce Wide Format Printer/OCE TDS400/14-Feb-14

Desired Result Net Sales  - 44265

According to your expression - 132795

[marcus_malinow]

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) ?

[aveeeeeee7en]

So what should I do in this case???

[marcus_malinow]

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?