above(total(expression)) not prodcuing desired result.

[#1]

Hi,

PFA - I have a dimension called department. I need to find various analysis using salary in the expression. When I try to find out total salary, irrespective of the department (means for whole organization), I was left with choice to use Set Analyis. Can we also use above(total()) as an alternative?

I need to correct my understanding on how above(total()) works. From help file it says: " if the expression is preceded by the total qualifier, the current column segment is always equal to the entire column". So, my understanding is using above(total(sum(salary))) gives the total salary of the organization a whole. I am sorry I am failed to interpret the help file's line.

But, neither sum({1} salary) nor above(total(sum(salary))) expression gives me the correct result. Additionally, I would be highly thankful if you please explain how above(total()) works.

Thanks!

[MK_QSL]

1) If you want TOTAL Salary irrespective of Department, you can use....

SUM(ALL salary)

or

SUM(TOTAL salary)

2) If you want TOTAL Salary Department wise... use below

RangeSum(Above(SUM(TOTAL <department> salary),0,RowNo(TOTAL)))

[jonathandienst]

Hi

I think you just need:

     Sum(TOTAL salary)

The total qualifier in the sum means ignore the dimension.

HTH

Jonathan

[MK_QSL · Accepted solution]

even for 2nd answer... you don't need RangeSum...

You can simply write...

SUM(TOTAL <department> salary)