Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am getting rounding issues below,
expression:
Count(IPA_MEMBER_ID) )*
(Round(((COUNT({<NOT_IN_FR = {0},RPT_MON = P({<RPT_MON =,Month=,YEAR=,DOS=>} DOS),SUBMITTER_ID = , CLAIM_TYPE= ,REGION =, IPA_Type=,YEAR=,Month=>} total <TAXONOMY_GROUP> DISTINCT ENCOUNTER_KEY)/
Count({<SUBMITTER_ID = ,RPT_MON = P({<RPT_MON =,Month=,DOS=,YEAR=>} DOS), CLAIM_TYPE= ,REGION =, IPA_Type=,YEAR=,Month=>}total <TAXONOMY_GROUP> IPA_MEMBER_ID))*12),0.01))) /12
It will be the easiest.
You do not need to share real data ....
Data is too big that why i couldn't attached. pls find sample
load less rows of course ...
only as many as is needed to reproduce problem
pls find the attachement
I understand, that you have problem with total result of Expected Claim ...
i added partial results, and they looks ok.
Look:
thanks Dariusz... Can you pls tell me how to added Partial results.
I took your expression for Expected Claim and created few additional expression from it with partial calculations to look what values are there. Take a look on attached application.
regards
Darek