2 Replies Latest reply: Apr 19, 2013 12:57 PM by Martins Freitas RSS

    Use Set Analysis

      hi,

       

      How transpormar following expression to set analysis ? For the exposed form generates the incorrect value, why not obey selection of products.

       

      sum (if (ProductName = 'CAPPUCPRONTO'), Vol_Umb/12, Vol_Kg)

       

      Thank you!

        • Re: Use Set Analysis
          sree anaarasi

          Hi use this

           

           

          =sum ({<ProductName ={'CAPPUCPRONTO'}>} Vol_Umb/12, Vol_Kg)

           

          is 

          Vol_Umb/12, Vol_Kg is one filed or 2 fields...  for one field it works fine

          if it is 2 fields use the aggregation..

           

           

          Aggr(sum ({<ProductName ={'CAPPUCPRONTO'}>} Vol_Umb/12), Vol_Kg)

           

           

          if not clear please post a sample of file with fields names..

            • Re: Use Set Analysis

              hi,

               

              Are two distinct fields.

               

              The expression did not show any results.

               

              I managed to solve the following expression, not very elegant, but gave the correct result.

               

              =sum({$<Nome_Familia1 = {"CAPPUCPRONTO"}>} Vol_Liq_Umb/12 ) + sum({$<Nome_Familia1 -={"CAPPUCPRONTO"}>} Vol_Liq_Kg)