Calculate the estimate of all shapes with a specific background color

Question

Anyone know if there is a formula to calculate the Estimate value of all shapes where the background fill color is a specific Hex value?

I’m still learning but here is what I have figured out so far...

I have a container with 2 shapes inside it with different fill colors.

I can calculate the number of shapes with a specific fill color using this formula

=COUNTIF(children(page), x => FILLCOLOR(x)
= HEXCOLOR('#e6e6ff'))

Result of the above above is 1 since I have 1 shape that matches that hex value.

And I can calculate the Estimate field using this formula:

=CONTAINED."Estimate"

The answer above is 5 (3 from one shape, and 2 from the other shape)

But I want some way to calculate the estimate field of ONLY the shapes that have a fill color of “#e6e6ff”

Best answer by Emma D

Hi @rmalick ! You might want to try using the FILTER function in your formula to return only the shapes with the specified fill color. Here is an example (assuming that you want to sum the data property values for the ‘Estimate” property on applicable shapes):

=SUM(FILTER(children(page), x => FILLCOLOR(x) = HEXCOLOR('#e6e6ff'))."Estimate")

View original

Emma D · Accepted Answer

Hi ​@rmalick! You might want to try using the FILTER function in your formulato return only the shapes with the specified fill color.Here is an example (assuming that you want to sum the data property valuesfor the ‘Estimate” property on applicable shapes):=SUM(FILTER(children(page),x=>FILLCOLOR(x)=HEXCOLOR('#e6e6ff'))."Estimate")

rmalick · Answer

That worked. Thank you!

Reply

Related topics

Hello From Coimbatore

Hello from Coimbatore

Hello, I have a problem when run by scheduled in A360. status Run bot Deploy Failed with message error: "User logged into console. Please log out before trying another multi-user deployments". Current condition just one device where the user login.icon

Hello from UAEicon

Connection error when running "Hello World" BOTicon

Create an account in the community

Log in to the community

Scanning file for viruses.

This file cannot be downloaded