I am trying to calculate a net margin into a repeating group (list of products) in order to give that info to customers (which are resellers - B2B business).
A buying price (exVAT) and a market price (VAT included) are already calculated based the current user and product ref. I want to make this calculation based on the two outputs of the current cell as follow:
(market price/1.2 - buying price)/(market price/1.2)
I can’t find a way to make this calculation. Any idea?