Forecast Date Issue
Hello,
I have the below color expression in a series
if (1=1, if (( CurrentRow ( ) > ForecastFirstRow()),
4259584 , if ( CurrentRow() = ForecastFirstRow() , 33023, 16711680)))
max_sales_date is 01-JUN-2018 in both my Dev and Prod instances , but in worksheet i am seeing different behavior:
In Dev, July is color 33023
In Prod , August is color 33023.
Note: Both Dev and Prod servers are in same timezone.
Please help me with this.
Thanks,
Kirti