SUM based on boolean at child Level

Saisri8568
Saisri8568
in Modeling

I have 2 lists 'BU' and 'Projects' , where Projects is child of BU list.

 

1. 'Projects Module' is dimensioned by Projects List

Saisri8568_0-1655887385672.png

2. Another Module 'Bu Module' is dimensioned by BU List

Saisri8568_2-1655887458484.png

The Amount Line Item in this module pulls data from 'Projects Module' summing it up by BU and quarter

3.Here I want to sum the data only if the boolean line item in 'Project Module' is not true

Saisri8568_3-1655887625874.png

Is there any way to achieve this without creating a new Line Item?

 

Thanks.

 

Tagged:

Best Answer

Answers

  • GeorgeDuckett
    GeorgeDuckett
    Create another line item in the Projects module which is the SumAmount that is something like IF No? THEN 0 ELSE Amount, and use that as the SUM.
  • Saisri8568
    Saisri8568
    Is there any way to achieve this without creating a new Line Item?

Categories