if to set analysis

[jasonseril]

hi to all,

can anybody change the expression below to set analysis? this is making the document's performance slow,

if

((

(

????='???' and ??????='??', num(sum({$<CityGroup1 = {'??'} >} CUST_CNT)/10000, '#,##0'),

if(????='???' and ??????='??', num(sum({$<CityGroup1 = {'??'} >} CUST_CNT)/sum({$<CityGroup1 = {'*'} >} CUST_CNT)*100,'#.##') & ' %',

thanks in advance, more power,

jason

[Miguel_Angel_Baeyens]

jasonseril wrote:????='???' and ??????='??',

Hi Jason,

Are green values variable names o fields? In this second case, try something like

Num(Sum({ $< CityGroup1 = {'...'}, green={'blue'}, green={'blue'} > }))

Unfortunately, quoting your charset gives me some wrong characters in the reply, so change my "green" for your expressions in green and "blue" for yours in blue.