formula

Sue van Niekerk

Hi Guys

I am after something simple

I want to add up production figures from the 01st of the month to the 15th of the month - then work out a percentage of that

that percentage will then form part of an alert to prod managers

Genevieve P.

Hi @Sue van Niekerk

A SUMIF Function should be able to do this for you!

I see that you're using hierarchy, so we can take the CHILDREN of this section as the Range to look in to each time. You can then specify what column to look at inside of the CHILDREN Function.

Try something like this:

=SUMIF(CHILDREN([Primary Column]@row), <= 15, CHILDREN(Actuals@row))

Cheers,

Genevieve