Markup percent computation (can also be used for performance report)

select itemcode, recentreceivedacquiredcost, srp ,

OriginalFormula = (srp - recentreceivedacquiredcost) / (case when recentreceivedacquiredcost = 0 then null else recentreceivedacquiredcost end),


OptimizedFormula = (srp / (case when recentreceivedacquiredcost = 0 then null else recentreceivedacquiredcost end )) - 1



from item