Percentage column

[#1]

Hello, please i need help with this

I have this table: 

Status	Pax	Pax %
Booked	3.329	-
Optioned	12.190	-
Cancelled	37.178	-
Revised	4.535	-
Quoted	48.635	1

I am trying to split the status by the quoted ammount being this the 100%. I attached a picture of the qlikview Formula

Thanks so much

Belén

[Gysbert_Wassenaar · Accepted solution]

Try num(sum(Pax)/sum({<Status={'Quoted'}>}TOTAL Pax),'0.0%')

[qlikview979]

Hi,

May be if u want like this   Go to Expression tab-->Select Expression--> Chick the (click)  Relative option

[#4]

Works! Thanks so much!