2 Replies Latest reply: Feb 12, 2013 2:47 PM by Jim Feng RSS

    Help please: My result is time frame insensitive.

      ='Total lbs Shipped: ' & num(if([Date Filter] = 'Both',

                                                                                      sum({<[Ship Date] = p(Date)> + <[Delivery Date] = p(Date)> + $<Carrier = {Boutin} >}lbs),

                                                                                      if([Date Filter] = 'Delivery',

                                                                                                sum({<[Delivery Date] = p(Date)> + $<Carrier = {Boutin} >}lbs),

                                                                                                sum({<[Ship Date] = p(Date)> + $<Carrier = {Boutin} >}lbs))), 

                                                                            '##,###.')& ' Lbs'

       

      im working for a trucking company, this is my code above, im trying to find out the volume we carry with our carrier "Boutin", but the result turn out to be time frame insensitive, doesnt matter how i change the time frame, the result doesnt change at all.

      please someone help me~~~