set analysis

[#1]

i have data in table like below

table1

total  sno

10        1

12       2

6          3

table2

price1	price2	sno
4	6	1
6	6	2
2	4	3

in want to use set analysis

count(  {<total={'>=10'} , total= {'>=if(isnull(price1)=-1,0,price1) + if(isnull(price2)=-1,0,price2)'}  >}     sno)

is this expression possible>???? for me giving empty chart

[#2]

In actual scenario i have some records which are total > price1+price2

[ashwanin]

Please tell, what actual you required in output .

[avinashelite]

try like this:

it will work but it should be double quots "" not the single quots ''

count(  {<total={">=10"} , total= {">=if(isnull(price1)=-1,0,price1) + if(isnull(price2)=-1,0,price2)"}  >}     sno)