SUM based on boolean at child Level
I have 2 lists 'BU' and 'Projects' , where Projects is child of BU list.
1. 'Projects Module' is dimensioned by Projects List
2. Another Module 'Bu Module' is dimensioned by BU List
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
Is there any way to achieve this without creating a new Line Item?
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.0
Is there any way to achieve this without creating a new Line Item?0