Return True if any Cell Value Within a Time Range Meets a Condition

sosunkwo
Frequent Contributor

Return True if any Cell Value Within a Time Range Meets a Condition

sosunkwo_0-1624587185645.png

Hello,

I'm trying to display a submit checkbox (boolean) on the dashboard. However, I only want the checkbox to be available if the cell value for all years have a value greater than 0. The years you see in the image is a Time Range (so, not Model Calendar). 

 

I would appreciate any insights on how to approach this. Thanks. 

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisHeathcote
Community Boss

Re: Return True if any Cell Value Within a Time Range Meets a Condition

@sosunkwo 

First, assign 'All Periods' as a summary option for the time range.

Add a boolean line item to your, 'Enter your % Growth' module. Call it 'Valid'.

Use formula =% Growth <> 0, Change summary method to 'All'.

The create a new flat module containing no dimensions. 

Add two boolean line items; 1. read 2. write

For read use formula =TRUE

For write use formula ='Enter your % Growth'.Valid[SELECT:Time.All Periods] This line item will only return a true outcome when 'All' years are valid and therefore containing a % growth.

 

Use these two booleans to set up DCA for the Submit? boolean

 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA

View solution in original post

3 REPLIES 3
Subhashree0112
New Contributor

Re: Return True if any Cell Value Within a Time Range Meets a Condition

Hi @sosunkwo 

From the screenshot provided i get that you also have a 'growth cell check' boolean line item, that is true only when there is value in the %growth line item. So you apply a DCA in the 'Submit' line item using the 'Growth cell Check' line item. Basically you need to select this line item i.e. 'Growth cell Check' in the write access driver option in the blueprint of the 'Submit' line item.

This will restrict the access of editing the line item only to the values where the Growth cell Check line item is true.

 

Hope this helps.

 

Thanks

Subhashree 

ChrisHeathcote
Community Boss

Re: Return True if any Cell Value Within a Time Range Meets a Condition

@sosunkwo 

First, assign 'All Periods' as a summary option for the time range.

Add a boolean line item to your, 'Enter your % Growth' module. Call it 'Valid'.

Use formula =% Growth <> 0, Change summary method to 'All'.

The create a new flat module containing no dimensions. 

Add two boolean line items; 1. read 2. write

For read use formula =TRUE

For write use formula ='Enter your % Growth'.Valid[SELECT:Time.All Periods] This line item will only return a true outcome when 'All' years are valid and therefore containing a % growth.

 

Use these two booleans to set up DCA for the Submit? boolean

 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA

View solution in original post

sosunkwo
Frequent Contributor

Re: Return True if any Cell Value Within a Time Range Meets a Condition

Thank you all! Your answers provided the insights that helped me solve the problem (which involved the two-step approach Chris laid out.) 

 

Thanks again!