1 Reply Latest reply: Dec 14, 2009 10:50 AM by Miguel Angel Baeyens de Arce RSS

    if to set analysis

    JASON SIGFRED SERIL

      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



        • if to set analysis
          Miguel Angel Baeyens de Arce

           


          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.