3 Replies Latest reply on Mar 5, 2013 3:08 AM by Prashant Sharma

    Budget calculation for distinct date

    Prashant Sharma

      Hi,

      I have to calculate the budget which is a single value for a date but there are different transactions done per day, so date field is repeated & when i take budget then it give me the sum for each transaction.

      eg: 

       

      Date          Budget

      2/3/2013     3300

      3/3/2013     4500

      3/3/2013     4500

      4/5/2013     6000

      4/5/2013     6000

       

      When i choose 4/5/2013 then budget field shows me 12000 but i want only 6000 for a date. How to solve this scenario?

       

      Thanks in Advance