Level 2 Sprint 2

Gayatri2020
Contributor

Level 2 Sprint 2

Iam unable to do conditional formatting and view of Line items(Intial and final forecast together).Attached 2 pics one with conditional formatting(connected to forecast cf ) and other without formatting.

How to get the below 

Gayatri2020_0-1602514312602.png

 

11 REPLIES 11
sguptatalkingrain
Contributor

Gayatri,

 

You have to apply conditional formatting in the saved view in model itself.

sguptatalkingrain_0-1602522504427.png

use this in my formula -

Use the Forecast cf line item to create the filter for the conditional formatting (if value is 1, apply formatting).

 

Hope this helps!

einas.ibrahim
Master Anaplanner/Community Boss

Hey @Gayatri2020 

 

I am not fully clear what the issue is. Could you please elaborate?
The image you included in the body of the post shows the view as it should be.
There is no relationship between conditional formatting and Line Items Show/Hide.

 

Are you saying that you can't change the view of your module to look like the image you included in your post?

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"

Dear community members
Consider posting your question as a new topic and not in the thread of another topic/question. This help other community members to easily find the answer they looking for and doesn't cause the original thread to be so cluttered that we can't find what we are looking for
Gayatri2020
Contributor

Resolved it myself please ignore

namrathanataraj
New Contributor

Hi can you explain, please?

 

CommunityMember129387
New Contributor

Hi Namratha,

 

You will have to apply the conditional formatting for Final Forecast based on Forecast cf as shown in the attached screenshot. Since Forecast cf is Boolean, the Minimum should be 0 and Maximum should be 1. Hope this helps.

Kkouibio
Occasional Contributor

Hi,

 i followed your direction but it is not showing selective color on the grid. this is how my view looks like. am i doing something wrong ? or missing something?

Kkouibio_1-1626564658709.png

 

 

Kkouibio_0-1626564592055.png

Can you help out?

Dineshrangaraju
New Contributor

Hi, 

 

Did you get solution to your problem...i am struck exactly where you have struck

16280869409234887647580445227278.jpg

am also experiencing the same issue.  I have set the conditional formatting to settings  above in chain:

 

jackstewartralphlaurencom_0-1629911605479.png

 Filter settings

jackstewartralphlaurencom_1-1629911656286.png

Can anyone help me?

I just figured it out.