Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
josephinetedesc
Creator III
Creator III

set analysis expression and plain aritmentic

Hello

I use

Sum(DurMins)/Sum(AvailMins) - correct answer

sum(DurMins/AvailMins) - is not correct

Now I want to make the expression always respond to the choice of Classification = Clinical (without an if statement) and Set Analysis is perfect for this:

How do I write my set analysis ...  I have not tried the wizard yet ...

sum({$<Classification = {'Clinical'}>}(DurMins/AvailMins))

Jo

1 Solution

Accepted Solutions
sunny_talwar

May be this:

Sum({$<Classification = {'Clinical'}>}DurMins)/Sum({$<Classification = {'Clinical'}>}AvailMins)

View solution in original post

3 Replies
sunny_talwar

May be this:

Sum({$<Classification = {'Clinical'}>}DurMins)/Sum({$<Classification = {'Clinical'}>}AvailMins)

josephinetedesc
Creator III
Creator III
Author

Thank you

Sunny T!

Happy New Year

sunny_talwar

Thank you and same to you