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

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.

Accepted answers

ChrisAHeathcote

@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

All comments

Subhashree0112

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

ChrisAHeathcote

@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

sosunkwo

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!

Ta1vien

I have a similar issue where I need to use a Line Item as Driver for an Action. But since the User Dimension is involved I can't use any aggregation. How could such a thing be solved?

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…