Answered

Filter and Sum a Collection

(0) Share

Report

Posted on by TB-20081424-0

220

Hi, hoping someone can help...I have a collection and I'm trying to sum two columns together in the collection. The sumtotal is blank???

I have Items = AddColumns(GroupBy(Filter(collectRecordMulti, Date >=varPayPeriodApproval2.StartDate && Date <= varPayPeriodApproval2.EndDate && Status.Value = "Approved"), "GIN", "GroupedGIN"), "NumRows", CountRows(GroupedGIN), "Sum_BonusRateValue", Sum(GroupedGIN, BonusRateValue), "Sum_DailyBonus", Sum(GroupedGIN, DayTotal), "SumTotal", Sum(GroupedGIN, "Sum_BonusRateValue"+"Sum_DailyBonus"))

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @TB05

Can you try this

AddColumns(GroupBy(Filter(collectRecordMulti, Date >=varPayPeriodApproval2.StartDate && Date <= varPayPeriodApproval2.EndDate && Status.Value = "Approved"), "GIN", "GroupedGIN"), "NumRows", CountRows(GroupedGIN), "Sum_BonusRateValue", Sum(GroupedGIN, BonusRateValue), "Sum_DailyBonus", Sum(GroupedGIN, DayTotal), "SumTotal", Sum( GroupedGIN, Sum( Sum( GroupedGIN, BonusRateValue ), Sum( GroupedGIN, DayTotal ) ) ) )

Was this reply helpful? Yes No
TB-20081424-0 220 on at

Like (0)

Report

Thank you, I'm not familiar with the WITH function. I'm trying to work with it and I continue to get invalid number of arguments and SUM has invalid arguments.

Was this reply helpful? Yes No
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @TB05

I have updated the formula above to simplify. Did you try this? Similar to one that you have been working.

AddColumns(GroupBy(Filter(collectRecordMulti, Date >=varPayPeriodApproval2.StartDate && Date <= varPayPeriodApproval2.EndDate && Status.Value = "Approved"), "GIN", "GroupedGIN"), "NumRows", CountRows(GroupedGIN), "Sum_BonusRateValue", Sum(GroupedGIN, BonusRateValue), "Sum_DailyBonus", Sum(GroupedGIN, DayTotal), "SumTotal", Sum( GroupedGIN, Sum( Sum( GroupedGIN, BonusRateValue ), Sum( GroupedGIN, DayTotal ) ) ) )

Was this reply helpful? Yes No
TB-20081424-0 220 on at

Like (0)

Report

Thanks for your quick response, that worked for me!

Was this reply helpful? Yes No