Relative in expression tab

[#1]

Hi

can any body tell me adv of relative property in expression tab

[alexandros17]

Compute the % from your expression and total amount of the expression

[#3]

can u please elobrate with example

[jvitantonio · Accepted solution]

Hello Venu,

When you check this option, you'll see the % representation of the values over the total.

As an example if you have the following dimension/values:

A = 50

B = 20

C = 30

you'll get the following output

A = 50% (A represents 50% of the total values) = Value of A * 100 / Total values (which in this example is 100)

B = 20% ( B represents 20% of total values)

C = 30% (C represents 30% of total values)

I hope this helps.

JV

[alexandros17]

Month, Val

Jan, 10

Jan,  5

Feb, 15

Mar, 40

Apr, 25

Expression is Sum(Val), Dimension is Month

so you will see in your table:

Month, Val

Jan, 15

Feb, 15

Mar, 40

Apr, 25

If you add relative:

Month, Val

Jan, 15, 0.1578 (=95/15)

Feb, 15, 0.1578 (=95/15)

Mar, 40, 0.025 (=40/95)

Apr, 25, 0.2631 (=25/95)