Sum of Costs associated with Item Issue

ambventure — Thu, 12 Aug 2021 21:42:31 GMT

I am struggling to set up a sum of Costs by Inspector. I've tried these and many others on the forums and youtube. I am happy to pay the person who can solve my problem $75 via PayPal.

Current setup:

Dimension "QB" is =if (Match([Transactions.Item Type], 'ServiceItem', 'InventoryItem', 'InventoryAssemblyItem', 'NonInventoryItem', 'OtherChargeItem', 'DiscountItem') and Match([Transactions.Txn Type], 'Invoice'), [Transactions.Item Type])

Dimension "Item" is Transactions.Item Full Name

Dimension "Type" is =if(([Transactions.Inventory Table] = 0) and (Transactions.Pending = 0 or IsNull(Transactions.Pending)) and Match([Transactions.Txn Type], 'Invoice','Sales Receipt', 'Credit Memo', 'Charge', 'ARRefundCreditCard'), [Transactions.Line Items Txn Type])

Expression "Fee" is sum([Item.Purchase Cost])

I did this because I have no data on the transactions.cost field

This is what I've tried.

=Aggr(Sum(TOTAL<[Transactions.Class Name]>[Fee],[Transactions.Item Full Name],[Transactions.Class Name]))

and all combinations thereof, I've pushed Dimensions to Expressions to see if one will help calculate the Fee column.

I don't know if this is a currency or amount issue, but the Transactions.Amount with Sign isn't populating any results.

I've tried the basic functions as well and i'm not sure how to get the total to add up correctly.

I appreciate any help!

Re: Sum of Costs associated with Product Item

Kushal_Chawda — Tue, 10 Aug 2021 21:46:06 GMT

@ambventure what is the expected total?

Re: Sum of Costs associated with Product Item

ambventure — Tue, 10 Aug 2021 22:22:38 GMT

The total should be 370 instead of 150

My chart is trying to add up associated cost per item instead of a cost per invoice by Inspector.

topic Sum of Costs associated with Item Issue in App Development

Sum of Costs associated with Item Issue

Re: Sum of Costs associated with Product Item

Re: Sum of Costs associated with Product Item