PL P&L Profit Loss Report

V5 Question
21

“ganancia” o “utilidad”

1 Like
22

So there is no shortened version like in English?

23

Yes, MG “margen de ganancia” or PU"porcentaje de utilidad"

1 Like
24

The Report Column Headers are arbitrary; you can change them to whatever you want.

Look at the Calculations that are being made and you should be able to derive the purpose of the Column and whether or not the resulting figure is something you would use.

FYI, the $vars like $3, $4, $5 are references to previous values, in this case, figures derived in previous Columns, for example:

[($4-$5)/$3]

That ^ means take the value calculated in Column 4 minus the value calculated in Column 5, then divide that by the value calculated in Column 3, where:

Column 1: C.Name.asc (not used in Calcs persay, but important as a "grouping" operator, so that operators like `.Sum` can be used)
Column 2: C.PortionName (again, not used, see above Column 1 description)
Column 3: C.Quantity.Sum
Column 4: [([C.AvgPrice]*[C.Quantity]).Sum]
Column 5: [([C.Cost]*[C.Quantity]).Sum]
2 Likes