Column with percentages

Hello,

I would like to insert a column with the percentages of the Profit and Loss statement related to Net Sales (see example below). How can I do it?

The cells in blue are calculated using Rules.

Best regards,

Gabriele

Find more posts tagged with

Accepted answers

All comments

Previous Member

Hi Gabriele Benecchi,

you will need to add two blocks in your layout

(a hidden) block that contains the values to which you want to compare your net sales
an algorithm computing the delta - it could be equal to a/b%
Ensure the block has the two decimals setting
You can then format this block so that it contains a % suffix

BR, Ray

unknown

Hello Ray Martens

Do you mean the following?

Is there any another way without adding a column with Net sales?

Best regards,

Gabriele

Previous Member

Just ensure that your second block is hidden:

Graeme Whorrall

Hi Gabriele,

Just looking at this think you don't want to have the block at all even hidden, you can use Nexel functionality so you can divide the current line from a specific line.

the @e;*;* is the current line block e and then the next is @e;1005;* is the solid reference to overheads which code is 1005.

hopefully I did not misread you in this.

regards

Graeme

PS forgot to say you can use a single rule in nexel.