0 Replies Latest reply: Jan 18, 2013 11:29 AM by Franck Martin RSS

    Please Help for sum in object text

      I try to build an indicator (sum) of the formula below :


      =sum(If(Today()-[D_ENTET.Date d'échéance de la pièce]>=0,sum({$<[D_ENTET.Module d'origine] = {"2 - Comptabilité"},[D_COMPTECPTA.Compte cumul 2] = {41}, NumPiece = >} [F_COMPTABLE2.Solde (D-C) en devise société]),0))


      There is no pb when the formula is in the tab with dimensions [NumPiece] and Customer (Tiers)  but i would like agregate the data by customer, like the TOTAL in the tab of the screenshot in the attachement.


      how to obtain the result 352274,4 in a variable or in a text object ? This result is the agregation of the details.


      When i make a SUM, it doesnt work !!! Please thank you by advance for your help.