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:





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





      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!!