6 Replies Latest reply: May 25, 2011 2:25 AM by Josetxo Amonarriz RSS

    Calculate Invoice Amount in Invoice Header

    Josetxo Amonarriz

      Hello,

       

      In the data source, there is no Amount field in the Invoice Header, it is calculated by making a sum of the Sales Lines table "Amount" field.

      But I would like to get that Invoice Total in the initial script (I can do it in the charts, but I'd like to have it in the script).

       

      Is there any aggregation function I could use for this purpose? Many thanks in advance.