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!