Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.