Create column % from other column values

[#1]

Hello,

I have a calculated expresion in the script to create a new column in my table. The calculate expresion is to obtain only the "Tipo actuacion" which finish in "1":

LOAD if(Right([Tipo actuacion],1)='1',[Tipo actuacion]) as [Notificaciones],

*;

The problem is that when I calculate a % column in a Pivot Table, it takes in consideration the other values (those which don't finish in "1" which appear in blank in the column "Notificaciones"), so the percentages aren't as I want.

[#2]

I have tried it, but it doesn´t appear anything in the cells

[tresesco]

This long chain could be minimized, if you could share your sample app with sample data.

[#4]

The problem is that I use Personal Edition, so I can´t open the file if you modify it

[rustyfishbones]

Apologies

Then say

SUM({<Notificaciones = {'*1'}>}Cantidad)/SUM(TOTAL {<Notificaciones = {'*1'}>}Cantidad)

or change Cantidad for your expression field

Regards

Alan

[rustyfishbones]

The result would be like this

[tresesco]

Let us have a look to find the actual issue, we could tell you then what to do.

[#8]

Solved,

The solution was this, but adding * before the 1:

((Sum({$ <Notificaciones={'*1'}>} Cantidad))/Aggr(NODISTINCT Sum({$ <Notificaciones={'*1'}>}Cantidad), [AñoExpediente]))*100

Now, I want to roung this percentage to 2 decimals

[alexandros17]

Delete the part *100 go in numbers, set decimal (2 digits) and check the box show in %

[#10]

Perfect! Thanks a lot!