14 Replies Latest reply: May 7, 2013 4:56 AM by David Workman RSS

    Straight table - sum total not working

      Hi,

       

      I'm really hoping someone can help me. I cannot attach the file I'm using so hopefully the details are clear enough below - I'm so confused!!!

       

      Within a table I have the following data:

       

      Client            Bill Date          Amount

      xxx               30/11/10           10,924

      xxx               22/06/10           15.650

       

      the Amount column works of the following expression:

       

       

      sum({$<[BILLINGS Bill Date]={">=$(cddate1)<=$(cddate2)"},CUR={$(=vSelCur)}>}[BILLINGS FeesBilled Amt])

      *

      sum({$<[BILLINGS Bill Date]={">=$(cddate1)<=$(cddate2)"},CUR={$(=vSelCur)}>}cdrate)

       

      which shows me a total of 26.574

       

      However if I remove the bill date from the above table, I get a total of 53,054! (using the same expression as above).

       

      Client             Amount

      xxx                  10,924

       

      I've looked on the website, and I suspect I need to use the aggr function within my expression, but I'm most probably wrong, why is the total not summing correctly and how can I get it to work?

       

      Thanks.


      Dave.