0 Replies Latest reply: Aug 12, 2017 1:29 PM by NEVILLE DHAMSIRI

# reference

Hi Sunny,

Thanks for response, but I do not get the results I expect. As you can see Ref_numbers, RA000C125  & EM000C200 are repeated more than once.I need to calculate a penalty of Rs 250 on each  policy which are in 'MC' class. I have got the answer as per the set expression I have given. But only issue is, it carries the charges on two duplicated policies as well. Just I need to design my formula to exclude this.

sum({<Ref_Number={'MC'}>}250).  Is there a way to bring in counting function to tackle this? or otherwise.

I need to calculate penalty of Rs250 for each cancelled policies. I base their reference numbers to do this.But some reference numbers are repeated & I should do the above calculation excluding those repeated numbers.In other words, Rs 250 to be charged only against one reference number. Here the reference numbers are dimension & the related premium value due to these reference numbers too are assigned which is a expression. To make this clear, I may present my case as below:

RA000C125           MC                     RA1C                         500

RA000C125           MC                      RA1C                         250 (duplicate)

RA000C128           FR                       RA1D                         320

RA000C150            FR                       RA1K                         250

EM000C200            MC                     EM1A                        100 (duplicte)

EM000C300            FR                      EM1B                         200

EM000C200           MC                        EM1A                         50

I have written expression as follows!

sum({<Ref_Number={'MC'}>}250)

As per above, Rs 250 is calculated twice on RA000125, EM000C200 Ref numbers. Help me to avoid this by having included some logic in to my above set analysis.

Thanks.

Neville