6 Replies Latest reply: May 30, 2013 3:04 PM by Juan Patricio Iorio RSS

    Set analisys duplicate

      Hi! im new is this group, sorry for my english.

       

      This is my problem: I have some tables:

       

      cars

      car_states

       

      and the value of the car, this coulb be in to tables:

       

      car_model

      car_price

       

      The car have an identity, unique. The problem is i need sum the car's price, and sum twice because state of the car, and i can't

      set distinct in set analisis because if two cars (they are unique by identity) have same price, get less the sum.

       

      the code:

       

      =sum( "some set analisis" if(isnull(car_price.price),car_model.price,car_price.price) )

       

      can somebody help me? Thanks!!