Set Analysis Expression Help

[sona_sa]

Hi Friends,

I have an expression which is: If(([P&L Level] = 's' or IsAdjustment = '1'), ,Sum({Period_1<CompanyName=$::CompanyName>}($(OpenBalanceExpression)))

Now I have to add a condition i.e.:

{$<MonthNum= {$(vMinMonth)}>}

How I can implement the same in my expression?

Thanks.

[tresesco]

If the state is same, try like:

If(([P&L Level] = 's' or IsAdjustment = '1'), ,Sum({Period_1<MonthNum= {$(vMinMonth)}, CompanyName=$::CompanyName>}.....

[jonathandienst]

Hi

Your example has syntax errors, so I am not sure exactly what you want:

If(([P&L Level] = 's' or IsAdjustment = '1'), Sum({$<MonthNum = {$(=vMinMonth)}> * Period_1<CompanyName=$::CompanyName>} ($(OpenBalanceExpression))))

or possibly

If(([P&L Level] = 's' or IsAdjustment = '1'), 0, Sum({$<MonthNum = {$(=vMinMonth)}> * Period_1<CompanyName=$::CompanyName>} ($(OpenBalanceExpression))))

HTH

Jonathan

[sona_sa]

Hi Jonathan,

Thanks....

I have used the same expression. But it is giving the output 0. But There is +ve and -ve values are there in database.

For ref. Please check the Table I have provided there in QVW. Also please find the attached qvw for more ref.

Thanks again for reply.