Apply map

[upaliwije]

I have in my data table following two data tables

Policy No	Pol_type	Nos
1	N	1
2	R	1
3	N	1
4	F	-1
5	R	1
6	F	0

  mapfleet

Policy No	Nos_Risks
1	1
2	3
3	4
4	0
5	1
6	0

I have applied the following script 

IF(MATCH(POL_TYPE,'N','R'),ApplyMap('mapfleet',POLICY_NO,'Null')AND IF(POL_TYPE='F',Nos))as NOS_RISKS

Although the script runs without any error result for the Nos_Risks is 0. Result should be 9

Pls see this correct my script

[Anil_Babu_Samineni · Accepted solution]

And operator can works only within IF statements. You can try this?

IF(MATCH(POL_TYPE,'N','R'),ApplyMap('mapfleet',POLICY_NO,'Null'), IF(POL_TYPE='F',Nos)) as NOS_RISKS

[prma7799]

Like this ??