2.4.7.1 Create Demand Forecast Grid UX saved view_unable to apply conditional formatting

SupriyaH

Hi,

 

I am not able apply conditional formatting to get the result. Could anyone please guide me.

required output - 

Applied conditional formatting - 

Got below output - 

 

Thank you,

Misbah

@SupriyaH 

 

In the EDIT RULE,

 

"Line item to Forecast" should be FINAL FORECAST

"Based on the Values" from FORECAST CF

 

Once conditional formatting is applied make sure you save the changes as Anaplan doesn't auto save conditional formatting changes

 

Hope that helps

Misbah

<Miz Logix>

SupriyaH

Hi @Misbah,

 

Still I am not getting required output. I have used below conditional formatting and got below output.

 

 

 

Please guide me how to proceed further.

Thank you,

SupriyaH

Hi @Misbah,



Still I am not getting required output. I have used below conditional formatting and got below output.



SupriyaH_0-1657875174875.png

SupriyaH_1-1657875459347.png





Please guide me how to proceed further.

Thank you,

Misbah

@SupriyaH 

 

Could you please share the formula for a line item "Forecast cf"

SupriyaH

@Misbah
"Forecast cf" -
IF Initial Demand Forecast = Final Forecast THEN 0 ELSE 1

Misbah

@SupriyaH 

 

Formula looks correct. You are applying CF on Final Forecast line, so check that line.

 

You won't see any differentiating colors unless there is a difference between the Initial Demand Forecast and Final Forecast. Try to put overrides and make Final Forecast diff than Initial Demand Forecast. Once that's done then you can check Final Forecast line.

 

Hope that helps

Misbah

Miz Logix