Hello, I want to multiply the stock amount and unit price of each product in the warehouse and collect them according to product groups.
The Stock Unit Price formula is as follows:
if(ref_smsbc4<0,if(fldcev<0,((fldfyt)*Parity/(fldcev)*(-1)),(fldfyt)*Parity*(fldcev))/(ref_smsbc4*(-1)),
if(fldcev<0,((fldfyt)*Parity/(fldcev)*(-1)),(fldfyt)*Parity*(fldcev))*ref_smsbc4)
The formula is a bit complicated, but there are conversion factors.
The formula for Stock Quantities is as follows:
sum((mzngrm + mznbgm) - (mznckm + mznbcm))
Each product code has a unit price and quantity in stock, and each product has a group.
I want to bring the total amounts of these products according to their groups.
However, when I multiply the stock amount formula with the stock amount formula, I cannot get the correct data according to the groups. How can I do this if I want to multiply and add them separately for each product and thus include them in the calculation by group?
