Unable to sum up negative values

[gauthamchilled]

Hi,

I have a bar chart where i am unable to sum up negative values.

it sum up only positive values but not the negative values. can any one help?

Regards,

Gautham

[sunny_talwar]

Would you be able to share a sample?

Best,

Sunny

[gauthamchilled]

find the attachment, in straight table it is showing the correct sum but not in the bar chart.

[gauthamchilled]

is it a bug or i have to change the expression?  any one help

[MK_QSL]

Alternate way to show sum is

expression

SUM(balance)

Remove Value on Data point from Expression Tab

Add one more expression, untick Bar and tick values on data point

SUM(Total <car> balance)

[maleksafa]

in your example you are saying that car c is showing 2000, it is correct. what are your expected values? for car c you have only one value which is 2000 so the sum will be 2000.

if you mean that for car b it is showing 2000 and -1000 and you want the sum to be 1000, then you need to remove the year dimension from the chart.

[jonathandienst]

Add a second expression:  if(Column(1) > 0, sum(total <car> balance), '')

Then turn off "Values on Data Points" for the first expression

Turn on "Values on Data Points" and turn off "Bar" for the second expression

HTH

Jonathan

[gauthamchilled]

Hi Jonathan,

thanks for the help, but in case of multiple expressions how to arrive the same. for example see the attached in this

[gauthamchilled]

for example in the attachment for car a it is showing 3000 instead of 1000

[gauthamchilled]

can any one help?