Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone!
Is it possible to combine and IF statement into the following please?
=Aggr (Only({<[Risk Class] = {'Property'},[Risk Class] -= {'Unspecified'},[Distribution Method] = {'Case Traded'}>}
[Distribution Method]),[Policy Number])
i.e. I would like to add in the following statements:
If([Annual Premium] < '20,000')
If(wildmatch([Salesperson],'*smith*'))
but I workout where in the set analysis (above) to include them. Can anyone help please??
Many thanks
Hi @krissy_s
try like below
It depends on requirement
=Aggr (Only({<[Risk Class] = {'Property'},[Risk Class] -= {'Unspecified'},[Distribution Method] = {'Case Traded'},Salesperson={"*smith*"}, [Annual Premium] = {"<20000"} >}
[Distribution Method]),[Policy Number])
or
=Aggr (Only({<[Risk Class] = {'Property'},[Risk Class] -= {'Unspecified'},[Distribution Method] = {'Case Traded'},Salesperson={"*smith*"}, [Policy Number] = {"=Sum([Annual Premium] )<20000"} >}
[Distribution Method]),[Policy Number])