RE conditional Formatting in Level 2 MB Sprint 2

Hi ,

 

Please help me how to create conditional formatting for below.

abhi12K_0-1641051920568.png

Thanks

Abhishek

Tagged:

Best Answer

Answers

  • Hi 

    @abhi12K 

    You need to write formula for the cf line item as  if initial fcst<> final fcst then 1 else 0 which indicates variance in the demand fcst 

    then for the final demand fcst line item , apply conditional formatting based on this cf line item using white blue color with 0 being white and blue as 1 

    it shall work 

    Kanishq17_0-1641407224349.png

    hope this helps

     

  • Hi @Kanishq17 ,

     

    I did same but formatting not applied this might be because in Cf line item for week 5 value is  70 instead of 71.

    But i think formulae that i used seems correct. please guide where i did wrong.

     

    abhi12K_0-1641455024643.png

    abhi12K_2-1641455317153.png

    Thanks

    Abhishek

  • Hi @abhi12K 

     

    I see value for final demand is same as initial demand , try checking the override box in that week and enter a value in override demand and then see if the cf works

     

  • Hi @Kanishq17 ,

     

    I have another issue that after activity '2.3.13 Activity: Create Global Demand Assumptions' my ux page values are not matching to provided Screenshot in Anaplan could you please guide me what change need to be make. 

    abhi12K_0-1641460764369.png

    abhi12K_1-1641460811354.png

     

    Thanks

    Abhishek

     

  • Hi @abhi12K 

     

    I believe the anaplan screenshot is just as a guide as to how the board page should look , yours seem fine , as for the values , if you have done as per the requirements , then you are good to go!