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.
regards
Franck