Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
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)