COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: adik on 08 May 2014 06:06:02 AM

Title: Total within set with substraction
Post by: adik on 08 May 2014 06:06:02 AM
Today I learned something new, maybe only I didn't know about this, but still maybe some will find it userful :
Insetead of calculating like: total([Measure] within set [Set1]) - total([Measure] within set [Set2])
you can shorten to: total([Measure] within set set([Set1], -[Set2]))

Do you guys have any other small "good to know"?