7 Replies Latest reply: Dec 14, 2017 11:39 PM by Yeo Poh sai RSS

    How to make Table 1 return 25,602-16,209= 9,393 amount , now it display 1599,664 is wrong.

    Yeo Poh sai

      Hi All



      I have below expression working fine :-


      If(Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=210'} >}total_ar  * 1) > 0,


      Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=210'} >}total_ar  * 1))



      After i modify the above expression to below , it does not return the correct value :-


      If(Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=210 & <360'} >}total_ar  * 1) > 0,


      Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=210 & <360'} >}total_ar  * 1))


      Where i go wrong ?


       


      Paul