sequence of if conditions affect results

[#1]

Hi All,

I have multiple if conditions in my expr.

Dimension as Month 1,2,3, Q1, 4,5,6, Q2, 7,8,9, Q3, 10,11,12, Q4, Year.

So I write in expr as

(If Month = Q1, expr1,

(If Month = Q2, expr2,

(If Month = Q3, expr3,

(If Month = Q4, expr4,

If Month =1, expr5,

If Month =2, expr6,

If Month =3, expr7,

If Month =4, expr8,

similarly for other months and year.

But i get  0 value against Q4.

So now if I change the order from Q1, Q2, Q3, Q4 to Q4, Q1, Q2, Q3 then I get value in Q4, but 0 in Q3.

I would like to know how does the sequencing will affect the expr?

[#2]

Hi Jonathan,

I could not give you the exact data with GL accounts, so I did give you the extract from QV file as sample data.

Yes we have data using GL Accounts.

Please can you do some modifications to my qvw and if required to data, so that I can get better idea.