I would like to calculate profit margin. I already have a formula field to calculate COGs. But, when I try to use the results of the COGS formula field in a new formula, it doesn’t work. Is that normal?

So, I tried this formula to bypass using a fiend in a formula that is itself the result of a formula. But I also cannot get this formula to work:

({LIST PRICE} - ((PRINT + MOUNT + SHIP) + (TIME * 25))) / {LIST PRICE}

Print, mount, ship, and time add up to my COGs, so I am trying to divide gross profit by list price to get profit margin. But it just returns a value of 1. The calculation is correct without the division by list price, as

{LIST PRICE} - ((PRINT + MOUNT + SHIP) + (TIME * 25))

Any suggestions?