3 Replies Latest reply: Mar 26, 2012 11:12 AM by Michael Ellerbeck RSS

    Convert chart formula in order to be able to display total in text box

    Michael Ellerbeck

      For an accounting straight table I have

       

      if(sum({1}total <BillTo> [First Exclusion]) / sum({1}total <BillTo> [TotalDue])>0.2 AND BBC='-' AND [Residual Short Pays]=0 ,sum(CurrentDue + DaysPast0To30 + DaysPast31To60),0)

       

      Basically if the sum of all the [First Exclusion] divided by the sum of all of the TotalDue is greater than .20 then pass through the sum of currentDue + DaysPast0To30 + DaysPast31To60

       

      I tried

       

      sum(if(sum({1}total <BillTo> [First Exclusion]) / sum({1}total <BillTo> [TotalDue])>0.2 AND BBC='-' AND [Residual Short Pays]=0 ,CurrentDue + DaysPast0To30 + DaysPast31To60,0))

       

      And I messed with aggr, but no luck

       

      Any thoughts and pointers much appreciated!

       

      -Michael