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,

Comments

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

  • 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,

  • 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 

     

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

  • @Misbah
    "Forecast cf" -
    IF Initial Demand Forecast = Final Forecast THEN 0 ELSE 1
  • @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