Need help on braces

[bharatkishore]

Hi All i have the following expression which is working fine,

=if((((Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]))

-

Avg(TOTAL {<Campaign = {"=Rank(((Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]))) <= 10"}>} Aggr((Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]), Campaign)))/

Avg(TOTAL {<Campaign = {"=Rank(((Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]))) <= 10"}>} Aggr((Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]), Campaign))

>0.10,'qmem://<bundled>/BuiltIn/led_g.png',

if((((Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]))

-

Avg(TOTAL {<Campaign = {"=Rank(((Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]))) <= 10"}>} Aggr((Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]), Campaign)))/

Avg(TOTAL {<Campaign = {"=Rank(((Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]))) <= 10"}>} Aggr((Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]), Campaign))

<-0.10,'qmem://<bundled>/BuiltIn/led_r.png','qmem://<bundled>/BuiltIn/led_y.png'))

But now i need to insert =sum([Unique Clickthroughs])/sum([Unique Opens]) instead of Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]..

Am struggling from hour to find the issue please help me in inserting those fields.

I kept dimension limits and this expression is working fine but for other expressions it is not working pls help

[sunny_talwar · Accepted solution]

May be this:

=if(((Sum([Unique Clickthroughs])/Sum([Unique Opens]))

-

Avg(TOTAL {<Campaign = {"=Rank((Sum([Unique Clickthroughs])/Sum([Unique Opens]))) <= 10"}>} Aggr(Sum([Unique Clickthroughs])/Sum([Unique Opens]), Campaign)))/

Avg(TOTAL {<Campaign = {"=Rank((Sum([Unique Clickthroughs])/Sum([Unique Opens]))) <= 10"}>} Aggr(Sum([Unique Clickthroughs])/Sum([Unique Opens]), Campaign))

>0.10,'qmem://<bundled>/BuiltIn/led_g.png',

if(((Sum([Unique Clickthroughs])/Sum([Unique Opens]))

-

Avg(TOTAL {<Campaign = {"=Rank((Sum([Unique Clickthroughs])/Sum([Unique Opens]))) <= 10"}>} Aggr(Sum([Unique Clickthroughs])/Sum([Unique Opens]), Campaign)))/

Avg(TOTAL {<Campaign = {"=Rank((Sum([Unique Clickthroughs])/Sum([Unique Opens]))) <= 10"}>} Aggr(Sum([Unique Clickthroughs])/Sum([Unique Opens]), Campaign))

<-0.10,'qmem://<bundled>/BuiltIn/led_r.png','qmem://<bundled>/BuiltIn/led_y.png'))

[bharatkishore]

Thanks a lot Sunny.. But i have 2 expressions like total contact and open rate .. the images are working fine for total contact top 10 and not working correctly fr open rate.. When  i disable this expression it is working fine.. Please help me how do i get this..