QV 9 and set analysis

[#1]

I am in the process of upgrading from 8.5 to version 9. Set analysis formulas created in 8.5 do do work in version 9, can anybody explain, e.g. sum({$<ON_order_no <>{''}>} despatched_qty)

[Miguel_Angel_Baeyens · Accepted solution]

Hello,

You can try

Sum({< ON_order_no = {"<>''"} >} despatched_qty)

If you are trying to avoid null/empty values try

Sum({< ON_order_no = {"=len(ON_order_no) > 0"} >} despatched_qty)

[#3]

Thanks, the second formula works. I have a large number of reports using set analysis and no doubt there will be a problem when I upgrate to version 9 SR2.

Is there an explanation as to why the formulas need to be changed?

[Miguel_Angel_Baeyens]

carneyfm wrote:Is there an explanation as to why the formulas need to be changed?

It may be because of the changes in Set Analysis, and probably documented in the release notes of V9. Not sure though