Column with percentages

Unknown
Unknown
edited April 2020 in Platform

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.

 

image

 

Best regards,

Gabriele

Answers

  • Previous Member
    Previous Member
    500 Up Votes 500 Likes 500 Comments Second Anniversary
    edited March 2020

    Hi Gabriele Benecchi,

    you will need to add two blocks in your layout

    1. (a hidden) block that contains the values to which you want to compare your net sales
    2. 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 % suffiximage

    image

    BR, Ray

  • Unknown
    Unknown
    edited March 2020

    Hello Ray Martens

     

    Do you mean the following?

     

    image

     

     

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

     

    Best regards,

    Gabriele

  • Previous Member
    Previous Member
    500 Up Votes 500 Likes 500 Comments Second Anniversary
    edited March 2020

    Just ensure that your second block is hidden:

    image

  • Graeme Whorrall
    Graeme Whorrall Active Partner
    Fourth Anniversary 10 Comments Level 200: Building A Planning Solution in Board Level 100: Foundations of Building in Board
    edited March 2020

    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.

    image

     

    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.

Categories