a dynamic colour in a line chart

[#1]

Hello! Can you tell me please, what am doing rong? I wanted the line to be blue if the debt is >0 and red if <0

=ColorMix1(if(Sum(debt)>=0,0,1),LightBlue(),red())

[JonnyPoole · Accepted solution]

You can use the rangesum(above()) expression in the background color to handle expressions where you are using 'full accumulation'.  You can also use the rangesum(above()) expression in lieu of the sum( field) with full accumulation in the expression formula as well. Your choice.

In the attached example, i used the latter and in the background color.

Let me know if its accumulating and coloring as you want.

[#3]

jpe , thanks!! thats what i need!! I  would be indescribably gratefull, if you look at my other question abut same app..calculate the age of debt, fifo payment/

Thank a lot!!!