SET modifier in Month doesn't work

[#1]

Hi all,

I am facing an issue on development with SET. We have the following SET statement calcuating the percentage change with previous data:

(sum({$<RiskMonth={$(=Only(Month))}>} Risk_Monthly_Total)- sum({$<RiskMonth={$(=Only(Month)-1)}>} Risk_Monthly_Total))/sum({$<RiskMonth={$(=Only(Month)-1)}>} Risk_Monthly_Total)

We found that the statement of sum({$<RiskMonth={$(=Only(Month)-1)}>} Risk_Monthly_Total) is not working. We tried to test the Month-1 in the same application on a new textbox, but it just worked fine (i.e, showing the previous month). No matter how we modified the statement, it's final result is Zero.

We have optimized our QVW data structure so no synthetic key exist. May anybody help out on this issue? Thanks in advance!

William

[#2]

Hi William,

please provide a small QV document we can work with.

Most of the time there are mixed formats if SET analysis is not working.

Rainer

[#3]

Hi Rainer,

Thanks for your instant response. Please find the trimmed version for your reference.

William

[#4]

Hi William,

RiskMonth, Month and RiskMonthly_Total did not have corresponding values in all cases (see the table box in the application).

It seems to me that this is the main problem you have.

Let me know if you need some more help.

Rainer