1 Reply Latest reply on Oct 4, 2013 10:53 AM by Dan Huff

    Filter on Percent Difference table calculation but still show each records raw values.

    Daniel Carr

      Hello,

       

      We have a table with 2 days' worth of data.

      i.e.

      TickerDatePrice
      ABC1/1/201310.00
      ABC1/2/20138.00

       

      We want to show the 2 prices next to each other then a calc'd Price diff field.  This works fine.

      The issue occurs when we want to filter by price change.  We only want to see where price change is > x%.and we still want to see both days' prices.  But, since 1/1/2013 has no previous day to calc against it is always returns NULLs and when we filter the data disappears.

      I have tried using SETS but cannot get that to work either.

      Any help appreciated.

      Sample attached.  Filter by CALC_PriceDiff and you'll see 1/1/2013 disappears.  Need some way (even using sets) to filter but still see both datas prices.

       

      Thanks,

      Dan