RE conditional Formatting in Level 2 MB Sprint 2

[abhi12K]

Hi ,

Please help me how to create conditional formatting for below.

Thanks

Abhishek

[Kanishq17]

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 

hope this helps

[abhi12K]

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.

Thanks

Abhishek

[Kanishq17]

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

[abhi12K · Accepted solution]

Hi @Kanishq17 ,

Thanks for your help its working fine.

[abhi12K]

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. 

Thanks

Abhishek

 

[Kanishq17]

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!