Total Percentages

[#1]

Hi all,

From the example seen below, instead of having 100% for the Sales %, how can I get the sum of the sales %'s?  i.e. Instead of 100%, I will have 99.9%?

Currently in my dimensions, I have something like this:

=aggr(if(rank(Sum({< TransactionType = {'PLSF'}, MN_Num = {$(vReportingDate)} >} CONTRACTED_Euro /1000000 ) * vDspCurrXrate  ) <= 10, Only({< TransactionType = {'PLSF'} >} [Client Group])), [Client Group])

[marcus_malinow]

You could try changing the Total Mode of your expression from Expression Total to Sum of Rows.

[#3]

Hi Marcus,

Its already set to sum of rows. But it has not made any differences

[marcus_malinow]

Ok then, it's likely that you have some values being rounded down.

For example

1.53

1.53

1.53

Sum = 4.59

In this example if you show it to 1dp, you'll see

1.5

1.5

1.5

Sum = 4.6

You could try using round in your expression

round ([Your Existing Expression], 0.1)

And retain Sum of Rows

[#5]

I understand what you just said, however, I dont want to round the values, I want to use them as they are

e.g. 38.2 + 29.8 + 17.6 etc.

Is this not possible?

[marcus_malinow]

If you use 0.1 as the second parameter for round, youll still see everything to 1dp

[rubenmarin]

Hi Sabah, the unrounded results (from the rounded sales data you posted) are:

16,3	38,2629108
12,7	29,8122066
7,5	17,6056338
1,4	3,28638498
1,1	2,58215962
0,8	1,87793427
0,7	1,64319249
0,7	1,64319249
0,7	1,64319249
0,7	1,64319249

and it sums 100, if you want it to sum 99,9 you need to round them to the first decimal as Marcus said.

[#8]

Thank you all for your help 🙂

[Anonymous]

Hi Try below logic and setting .

See the example. You will get 99.9 % for your expression.