Hello,
I have a chart with this Dimension:
= If (YEAR(JWX) *100 + Week(JWX) < (Year(AddMonths(Today(1),-1)) *100 + Week(AddMonths(Today(1),-1)) +1 ) , '<= ' & (Year(AddMonths(Today(1),-1)) *100 + Week(AddMonths(Today(1),-1))), YEAR(JWX) *100 + Week(JWX))
And for the color I write this: =if ( YEAR(JWX) *100 + Week(JWX) = YEAR(today(1))*100 + Week(today(1)) , green())
What must I do, to have the color.
in QV