This content has been marked as final. Show 6 replies
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.