Set Analysis question

[jduenyas]

Hi All

What is the difference between these to statement? :

sum({<OrderedTotal = {"<>0"}>}OrderedTotal)

sum({<OrderedTotal -= {0}>}OrderedTotal)

And which is correct?

(The returned results are different)

Thanks

[sunny_talwar]

Without selection, both should give you the same result, but will give different results based on user selection in OrderedTotal field.

sum({<OrderedTotal = {"<>0"}>}OrderedTotal) -> no impact with selection in OrderedTotal

sum({<OrderedTotal -= {0}>}OrderedTotal) -> will show everything in your current selection except 0 when you select something OrderedTotal.

[jduenyas]

Thanks

[sunny_talwar]

Not a problem