5 Replies Latest reply: Apr 13, 2010 3:08 AM by Blessy Jeyantha RSS

    Restricting Duplicates in Chart Expressions

    Blessy Jeyantha
      Hi My table contains fields ->RegisterId ->StartDate ->EndDate I have duplicates in RegisterID In Layout, I have Guage chart which shows the average of (EndDate-StartDate) Since RegisterId contains duplicates ,Average showing is wrong. I dnt want to remove duplicates when loading my table. I just want to restrict duplicates in Gauge chart expression. Existing Formula is avg(EndDate-StartDate) Any Suggestions?