Negative values with a condition

[#1]

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.

[sunny_talwar]

Uploading a Sample

[#3]

HERE IT IS! sorry i was kinda lost, i was able to use the FALSE thing but couldnt make the negative thing work

[zebhashmi]

I would say

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

[sunny_talwar · Accepted solution]

Check this out

[#6]

Thank you! this works!

[sunny_talwar]

Awesome