Set analysis

[madhuqliklondon]

I am trying to count orders under £15 pounds and I am using this set analysis but its not taking all the products line values, i think I need to add sum in set analysis ,So can i do that

=Count({<[IO.GBP Amount (ex VAT)]={"<15"}>}DISTINCT [IO.Original Order No_])

Where sum goes??

[sunny_talwar]

There might be few orders which are exactly 15? because your conditions are < 15 and > 15, =15 is getting excluded?

[madhuqliklondon]

I will try with that Sunny.