topic filter sum by number value in App Development

filter sum by number value

kryan — Tue, 13 Jul 2021 18:46:21 GMT

Hello, I have a sum of costs in a table that is organized by project. I want to only display the sum of the cost if the total is below -5,000. Any suggestions on how to do this?

Re: filter sum by number value

kaushiknsolanki — Tue, 13 Jul 2021 18:57:06 GMT

You can try simple method.

If(Sum(Cost)<=-5000,Sum(Cost))

You can also convert this into set analysis.

Sum({<Project = {'=sum(Cost)<=-5000'}>}Cost)