Set Analysis

[krishna20]

Hi friends !

I have to find outstanding amount for the claims paid of whole year.

for e.g.,

There is loss occurred on date 20-05-2013.

It intimated to company on 25-05-2013 loss occurred of 20000/-.

on 31-07-2013 we settled a amount of 5000 and remaining amount is 15000.

on 29-11-2013 we settled a amount of 6000 and remaining amount is 9000.

Now ,i need to find out the outstanding amount for the year of whole claims

I'm having the variables vCurrentYear,vCurrentYear-1 and vCurrentyear-2.

Currency field is CE_AMT_LC1.

Anyone pls suggest me how to apply set analysis for this situation ASAP.

Advance thanks,

Regards

krishna

[avinashelite]

Hi Kalyan,

Please find the attached QVW file for solution.

Hope this is what your looking for.

Regards,

@vi

[krishna20]

Hi Avinash.

I didnt find any attachment.Please send me again.

Regards

Krishna

[avinashelite]

Hi Kalyan,

Please find the attached QVW file for solution.

Hope this is what your looking for.

Regards,

[Anonymous]

Hi,

Below set analysis script may help you to calculate remaining_amount,

Sum({<date_field={"$(=Date(Max(date_field)))"}>} remaining_amount)