topic Please Help for sum in object text in QlikView https://community.qlik.com/t5/QlikView/Please-Help-for-sum-in-object-text/m-p/435535#M488350 <HTML><HEAD></HEAD><BODY><P>I try to build an indicator (sum) of the formula below : </P><P></P><P>=sum(If(Today()-[D_ENTET.Date d'échéance de la pièce]&gt;=0,sum({$&lt;[D_ENTET.Module d'origine] = {"2 - Comptabilité"},[D_COMPTECPTA.Compte cumul 2] = {41}, NumPiece = &gt;} [F_COMPTABLE2.Solde (D-C) en devise société]),0))</P><P></P><P>There is no pb when the formula is in the tab with dimensions [NumPiece] and Customer (Tiers)&nbsp; but i would like agregate the data by customer, like the TOTAL in the tab of the screenshot in the attachement.</P><P></P><P>how to obtain the result 352274,4 in a variable or in a text object ? This result is the agregation of the details.</P><P></P><P>When i make a SUM, it doesnt work !!! Please thank you by advance for your help.</P><P></P><P>regards</P><P></P><P>Franck</P></BODY></HTML> Fri, 18 Jan 2013 16:29:46 GMT 2013-01-18T16:29:46Z Please Help for sum in object text https://community.qlik.com/t5/QlikView/Please-Help-for-sum-in-object-text/m-p/435535#M488350 <HTML><HEAD></HEAD><BODY><P>I try to build an indicator (sum) of the formula below : </P><P></P><P>=sum(If(Today()-[D_ENTET.Date d'échéance de la pièce]&gt;=0,sum({$&lt;[D_ENTET.Module d'origine] = {"2 - Comptabilité"},[D_COMPTECPTA.Compte cumul 2] = {41}, NumPiece = &gt;} [F_COMPTABLE2.Solde (D-C) en devise société]),0))</P><P></P><P>There is no pb when the formula is in the tab with dimensions [NumPiece] and Customer (Tiers)&nbsp; but i would like agregate the data by customer, like the TOTAL in the tab of the screenshot in the attachement.</P><P></P><P>how to obtain the result 352274,4 in a variable or in a text object ? This result is the agregation of the details.</P><P></P><P>When i make a SUM, it doesnt work !!! Please thank you by advance for your help.</P><P></P><P>regards</P><P></P><P>Franck</P></BODY></HTML> Fri, 18 Jan 2013 16:29:46 GMT https://community.qlik.com/t5/QlikView/Please-Help-for-sum-in-object-text/m-p/435535#M488350 2013-01-18T16:29:46Z