Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Just wondering what is -1 or 1- indicate when we do division in the expression.
eg-
1- Sum(Cost)/sum(Sales)
or
column(1)/ column (2) -1
So, in above expressions what is the significance of 1- in first expression and -1 in the second expression?
Thanks
For example
1- Sum(Cost)/sum(Sales)
equals
( Sum(Sales) - Sum(Cost) )
/
Sum(Sales)
which could be read as profit percentage (in relation to sales)
Division precedes the subtraction, so it's basically
1 - DivisionResult
vs.
DivisionResult -1
Hence both expressions differ in sign.
Thanks Stefan.
Could you tell me why the business want to substract. I mean what is the general use case.
For example
1- Sum(Cost)/sum(Sales)
equals
( Sum(Sales) - Sum(Cost) )
/
Sum(Sales)
which could be read as profit percentage (in relation to sales)
Thanks