Any workarounds you can think off?
# generals
Sergio
04/27/2020, 4:54 PMAny workarounds you can think off?
b
battk
04/27/2020, 5:01 PMmight want to explain this better
battk
04/27/2020, 5:02 PMdont know how you have a problem adding quantity on hand multiple times if it only happens one per each transaction line
s
Sergio
04/27/2020, 5:02 PMquantity on hand its always the same value on each transaction, its getting pulled from the item record.
Sergio
04/27/2020, 5:03 PMquantity is different based on the item fulfillment
s
suitemike
04/27/2020, 5:03 PMAre you using item fields?
suitemike
04/27/2020, 5:03 PMDo item fields: Quantity on Hand
suitemike
04/27/2020, 5:04 PMSo it’ll pull from the item record instead of the transaction
s
Sergio
04/27/2020, 5:07 PMyes, but I need to pull that field
s
suitemike
04/27/2020, 5:07 PMDoesn’t that field pull from the item record anyway?
s
Sergio
04/27/2020, 5:07 PMit is
Sergio
04/27/2020, 5:07 PMthis is my formula (very basic)
Sergio
04/27/2020, 5:08 PM{quantity}/{quantity}+{item.quantityonhand})
s
suitemike
04/27/2020, 5:08 PMCan you wrap that in a max?
b
battk
04/27/2020, 5:08 PM{quantity}/({quantity}+{item.quantityonhand})
battk
04/27/2020, 5:09 PMstill dont know what you are trying to calculate
s
Sergio
04/27/2020, 5:09 PMThats what Finance is trying to get to... Some metric they need
Sergio
04/27/2020, 5:10 PMquantity fulfilled / quantity fulfilled + Total Inventory on Hand
Sergio
04/27/2020, 5:10 PMand this is grouped by SKU
Sergio
04/27/2020, 5:13 PMFor Example,
Sergio
04/27/2020, 5:14 PMmessage has been deleted
Sergio
04/27/2020, 5:14 PM2747/(2747/5540) = .3314
Sergio
04/27/2020, 5:17 PMThe result is wrong, because when doing a SUM of the formula, its adding 5540 (Quantity on hand) multiple time due to being pulled in every line
Sergio
04/27/2020, 5:17 PMmessage has been deleted
Sergio
04/27/2020, 5:18 PMits calculating 2747/(2747+9639600)
b
battk
04/27/2020, 5:19 PMshare the result columns
s
Sergio
04/27/2020, 5:21 PMmessage has been deleted
b
battk
04/27/2020, 5:34 PMi think you want SUM({quantity})/(SUM({quantity})+{item.quantityonhand})
battk
04/27/2020, 5:34 PMi havent had any luck doing those with summaries
battk
04/27/2020, 5:35 PMyou might have better luck doing the opposite and do an item search using the transaction join
✔️ 1
battk
04/27/2020, 5:36 PMyou might be able to avoid using summaries that way
s
Sergio
04/27/2020, 5:37 PMI was about to try that
Sergio
04/27/2020, 5:38 PMand your example of the formula is exactly what I want
Sergio
04/27/2020, 5:55 PMDoestn work recreated as an item search, I still have to group by item name to group all transaction lines
Sergio
04/27/2020, 5:55 PMmmmmm
d
donna
04/28/2020, 1:41 AMhave you tried setting Main Line = True?
3 Views