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