Hi,
I am trying to set up a Gross Profit column that takes the following results
Bespoke Price (Numbers Column)
Package Price (Formula Column)
then Subtracts a column called SS Pay if either of the columns/rows if one of these has a figure in it and display blank otherwise.
I keep having issues when i try to introduce anything more than 1 string for the formula for example this works -
IF({Bespoke Price} > 0,{Bespoke Price}-{SS Pay},“”)
but any more than this involving the package price string gives me an invalid parameter for bespoke price. Only one row at a time will have data in, for example there will only be a bespoke price OR package price in a single row.