Power Platform Community Forum Thread Details

ForAll calculation within Collection

Hi,

I have a collection that returns the transaction types based of a available options of a column using the distinct function (this is working).

But when I try to calculate the outstanding count, it returns the same value for all the different transaction types. Any idea what is not working in my formula?

ClearCollect(
    TransactionSummary,
    ForAll(
    Distinct(EmployeeTransactions,TransactionType.Value),
    {TransactionType: ThisRecord.Value,
    OutstandingCount: CountIf(
                EmployeeTransactions,
                Status.Value <> "Completed" && TransactionType.Value = ThisRecord.TransactionType.Value
            ),
            ProgressPercentage: RoundUp(
                (CountIf(
                    EmployeeTransactions,
                    Status.Value = "Completed" && TransactionType.Value = ThisRecord.TransactionType.Value
                ) / CountIf(
                    EmployeeTransactions,
                    TransactionType.Value = ThisRecord.TransactionType.Value
                )) * 100,
                0
            )
        }
    )
);



Are is the result I am getting: it returns the total outstanding count in my datasource and applies it to every row.