RE conditional Formatting in Level 2 MB Sprint 2

abhi12K
Contributor

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

1 ACCEPTED SOLUTION

Accepted Solutions
abhi12K
Contributor

Hi @Kanishq17 ,

 

Thanks for your help its working fine.

View solution in original post

6 REPLIES 6
Kanishq17
Community Boss

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

 

abhi12K
Contributor

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

Kanishq17
Community Boss

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
Contributor

Hi @Kanishq17 ,

 

Thanks for your help its working fine.

abhi12K
Contributor

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

 

Kanishq17
Community Boss

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!