15 Replies Latest reply: Jun 13, 2017 10:16 AM by Sunny Talwar

# Negative values with a condition

Hi,

I am trying to show a graph of sales where i have returned things in negative.

I also have a contion that allows me to show if the sale is on a especific program:

Sum({\$<Duplica={"0"}>}[SumOfTEVSEQ01])

I would need to show the negative values in the graph but i dont know how.

Thank you.

• ###### Re: Negative values with a condition

Is your expression not showing negative values? Can you share a sample to take a look at?

• ###### Re: Negative values with a condition

The graph do not totalize correctly. cause it should be 208.820... 7 are returned items so they are negative -7

It sais

• ###### Re: Negative values with a condition

Try with this

and this formula:

Sum({\$<Duplica={"0"}>}[SumOfTEVSEQ01])

it does not sum the negatives.

• ###### Re: Negative values with a condition

What is Duplica here?

• ###### Re: Negative values with a condition

Duplica is the mark for the program so if its false I should  sum it  and if its true I should not take it into consideration.

• ###### Re: Negative values with a condition

Does Duplica include 0 and 1 or False and True? This seems to be working for me

Sum({\$<Duplica={'FALSE'}>} SumOfTEVSEQ01)

• ###### Re: Negative values with a condition

I tried this but the graph becomes empty

• ###### Re: Negative values with a condition

I would say

1- Sum({\$<Duplica={"0"}>}[SumOfTEVSEQ01])

• ###### Re: Negative values with a condition

Thank you! this works!

• ###### Re: Negative values with a condition

Awesome