sum of field in set analysis

[#1]

i want to use expression like

count(total_Amount = {<'>=base_amount+offer_value'>} id)

is it possible to doing sum of two fields?

[alexandros17 · Accepted solution]

Count(id) is correct, unfortunately your set analysis does not work:

1) count({$ <total_Amount = {'>=base_amount+offer_value'}>} id)

but this is not enough because the right side of set analysis must have only 1 value computed as aggregation, you cannot use one (and obviously 2 or more) fields in this way.

you could use a Max(base_amount+offer_value) ..

hope this helps

[Gysbert_Wassenaar]

Maybe, maybe not. It depends. See this document for more information: set_analysis_intra-record.qvw