ref line not working

[soniasweety]

Hi all

I have tried to use add reference line in bar chart presentation tab .

but when I use expression like below

if(sum(sales)>100,red(),green()) 

but its not reflecting  ,

where am doing wrong?

[YoussefBelloum]

Hi,

the expression used here is a coloring expression, did you used on the reference line expression part ?

[soniasweety]

yes I used this in ref line add  --- definition

I added .

[YoussefBelloum]

this will not work, like I said it is a color expression.

you need to define the value of your reference line before..

[stabben23]

show us a snapshop of the settings in Reference lines.