I am facing a challenge using “Do a search for” for Repeating Group datasource for Nested types using calculation from one of the nested Type.
Kindly see the attached photo for the structure and desired output through search.
I want to show the Output-1 & Output-2 in a repeating group using the TWO TYPES as shown in the image.
Car Name = Car Name from CAR TYPE
Repair Permitted = Repair Permitted from CAR TYPE
Total Repair Amount = Sum of all the repair amounts of a particular car from REPAIR TYPE
Balance Repair Amount = Repair Permitted (CAR TYPE) - Total Repair Amount (REPAIR TYPE)
To Be Charged = YES, If Balance Repair Amount < 0 else NO