Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET @rn=1;
- SELECT
- '' AS `Price`, /* A */
- p.weight AS `Weight`, /* B */
- p.cost AS `Cost`, /* C */
- CONCAT('=IFERROR(ROUND(A', @rn, ' - C', @rn, '), 2), 0)') AS `Profit $`, /* D */
- CONCAT('=IFERROR((D', @rn, '/C', @rn, ')*100, 0)') AS `Profit %`, /* E */
- @rn:=@rn+1 AS `Row`
- FROM
- products p
- WHERE
- p.avail > 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement