Please help me how to create conditional formatting for below.
Go to Solution.
Hi @Kanishq17 ,
Thanks for your help its working fine.
View solution in original post
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
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.
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
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.
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!