Background color issue on QTD, MTD and YTD differences

[Emir_Peker]

Hello everyone,

I am currently working on present and previous year QTD, MTD and YTD. I am trying to show the differences with color, but sadly, not working properly and I cannot see what I did wrong so I wanted to get some insight from you all. Here are my difference codes. Also, I couldn't do the qtd difference, would be nice if someone helped out.

Difference QTD 😞

Difference MTD Color Code:

=IF(
(
(Sum({<YIL, AY, CEYREK, FATURATARIHI, DateNum={">=$(=Num(MonthStart(Max(DateNum))))<=$(=Max(DateNum))"}>} SATIRNETTUTARI)
/
Sum({<YIL, AY, CEYREK, FATURATARIHI, DateNum={">=$(=Num(MonthStart(Max(DateNum), -12)))<=$(=AddYears(Max(DateNum), -1))"}>}SATIRNETTUTARI)
)
-1
)>=0,  rgb(0,200,0), rgb(200,0,0))

Difference YTD Color Code:

IF(
(
(Sum({<YIL, AY, CEYREK, FATURATARIHI, DateNum={">=$(=Num(YearStart(Max(DateNum))))<=$(=Max(DateNum))"}>} SATIRNETTUTARI)
/
Sum({<YIL, AY, CEYREK, FATURATARIHI, DateNum={">=$(=Num(YearStart(Max(DateNum), -1)))<=$(=AddYears(Max(DateNum), -1))"}>} SATIRNETTUTARI))
-1
)>=0,  rgb(0,200,0), rgb(200,0,0))

This is how it shows, sadly everything is red even tho some are above 0%

[Emir_Peker · Accepted solution]

Found the solution on my own. Still thanks to everyone and sorry to disturb.