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

SupriyaH
Contributor

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

Hi,

 

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

required output - 

SupriyaH_0-1657680681195.png

Applied conditional formatting - 

SupriyaH_1-1657680720920.png

Got below output - 

SupriyaH_2-1657680853063.png

 

Thank you,

6 REPLIES 6
Misbah
Moderator

@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
Contributor

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,

SupriyaH
Contributor

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
Moderator

@SupriyaH 

 

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

SupriyaH
Contributor

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

@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