Can anyone help me with this? In the Data file TotalLineAmount has negative values which indicates the credits. Gross amount is the sum of all positive and negative values.
I am not fully clear as to what you are looking for...
If you want to drop the negative sign then you can use the fabs() function.
This will ensure that you are working with only positive numbers. For example:
fabs( 2.4 ) returns 2.4
fabs( -3.8 ) returns 3.8
If you want to keep the signs and net the numbers off by ItemID or CurrencyCode for example then you could use the Aggr() function. The below example would give you a single number per ItemID.
Thanks for your reply. What i actually want is to calculate the credit amount (negative LineAmount) for ItemID A,B,C and L. Gross & Net Quantity for ItemID A,B,C and L. Gross & Net Amount for ItemID A,B,C and L. Your reply contains for All ItemID not for specific items.
I am attaching the apps here. Could you please have a look at it and suggest me. Also could you have a look at the chart for the Credit and Net amount over time? !
