Hi all,
I have looked at other posts related to my question but have had no luck finding an answer. Any help is appreciated.
I have a calculation that counts all approved claims for all months greater than the one selected.
However, I need to only count the approved claims when the claim was denied in the month selected.
For example: WHEN [DETRMN_DISPOSITION] = 'Denied' FOR Only([DETRMN_RPT_MTH_DATE_SKEY]) THEN count({$<[DETRMN_DISPOSITION]={'Approved'},[DETRMN_RPT_MTH_DATE_SKEY]={">$(=Only([DETRMN_RPT_MTH_DATE_SKEY]))"}>} [DETRMN_AUTH_CLAIM_NBR])
This is the formula I am using now but am getting all approvals regardless if it was denied.
=count({$<[DETRMN_DISPOSITION]={'Approved'},[DETRMN_RPT_MTH_DATE_SKEY]={">$(=Only([DETRMN_RPT_MTH_DATE_SKEY]))"}>} [DETRMN_AUTH_CLAIM_NBR])