Sum IF question

[BrunPierre]

ID	R_Type	R_Company	%_CONTRIBUTION
FAR	C	F0	0
FAR	C	F0	40
FAR	F	F5	0
FAR	F	F5	54.17
FAR	T	FS	0
FAR	T	SS	22

Hello guys!

With the above I'd like to perform a conditional s

For every R_Type , sum the %contribution based on the R_company, that is

IF R_Type  = C and R_Company is unique (F0), then 0 + 40 = 40

IF R_Type  = F and R_Company is unique (FS and SS), then 0 + 54.17 = 54.17

IF R_Type  = T and R_Company is not unique (F5 & SS), then 0 + 22 *(2) = 44 because there are two distinct R_Company.

Thanks

[rubenmarin · Accepted solution]

Duplicated here: https://community.qlik.com/t5/QlikView-App-Development/Conditional-Sum-Question/td-p/1596914