1. TARGIT Community
  2. Community
  3. General Discussion
Knowledge Base

Calculation - percentage per line

Dan Lykholt ·

Hello everyone,

Trying to get Targit to show percentage per line of the Total. Example below:

The "Total" 1705 Tryktræ should be = 100%. Then "Grundsortiment" should be (1.679.846 / 2.079.544) = 80,77%

The percentage for "Hjemtagelsesvarer" should be (174.036 / 2.079.544) = 8,37%

How do I set this up? Can anybody help. Thank you in advance 😊  

0

Comments

1 comment
Sort by DateVotes
  • Ole Dyring

    Hi Dan,

    Insert a custom calculation "As a new measure".

    Try this syntax:

    sum(0, 0, m1) / sum(all, 0, m1)

    The calculation should be number formatted as 'Percent'.

    BR / Ole

     

    0
Please sign in to leave a comment.