Using set analysis within abvove function

[#1]

Hi,

I have a requirement  wherein I need to calculate the sum of the above 3 rows as my 4th row for which I am using above function and it seems to be fine but the problem is when I make a selection on the year it is turning out to be  zero which is not correct and hence I believe if I can use set analysis and bypass the selections I can achieve the desired results. So please guide on how to go with it

Expression currently used is

=if(BS_No=50,above(Column(1),1)+above(Column(1),2)+above(Column(1),3),
if(BS_No=100,above(Column(1),1)+above(Column(1),2)+above(Column(1),3),
if(BS_No=120,above(Column(1),2)-above(Column(1),7),
if(BS_No=10 or  BS_No=60 or BS_No=110 or BS_No=130,' ',

sum( $(vSet),FY = {"$(vPrevYear)"},[Month Name]=>} AMOUNT)/Denominator))
))

[tresesco]

Set can't be used in above(), because that is not an aggregation function. However, you could probably have an alternative to resolve the issue. Can you post your sample qvw that demonstrates the issue?

[alkesh_sharma]

Check the IF condition syntax.

First if condition ends @if(BS_No=50,above(Column(1),1)

after the plus operator above(Column(1),2) here ,2 means nothing