Hi,
I have some query about formula, I tried by unable to found correct answer.
The error is coming if outstanding amount is given then count showing in paid and outstanding coloumn.
You can check below conditions and put the date in data sheet then you will know the error.
If paid claim given then count will be only paid = correct
if paid claim & outstandng cliam given then count will be only Outstanding claim. = ?
if only outstanding claim given then count will be only outstanding claim = wrong
if zero amount given in paid then count will be paid claim count and if zero amount given in outstanding claim then count will be outstanding claim only.= ?
please check Data sheet and Summery sheet in attach file.
Regards
Dnyan
I have some query about formula, I tried by unable to found correct answer.
The error is coming if outstanding amount is given then count showing in paid and outstanding coloumn.
You can check below conditions and put the date in data sheet then you will know the error.
If paid claim given then count will be only paid = correct
if paid claim & outstandng cliam given then count will be only Outstanding claim. = ?
if only outstanding claim given then count will be only outstanding claim = wrong
if zero amount given in paid then count will be paid claim count and if zero amount given in outstanding claim then count will be outstanding claim only.= ?
please check Data sheet and Summery sheet in attach file.
Regards
Dnyan