Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
santharubban
Creator III
Creator III

Rounding Issues

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_GROUPDISTINCT 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

16 Replies
Not applicable

To try to find the issue, we must view it in the application, not in the picture.

It will be the easiest.
You do not need to share real data ....

santharubban
Creator III
Creator III
Author

Data is too big that why i couldn't attached.  pls find sample

Not applicable

load less rows of course ...

only as many as is needed to reproduce problem

santharubban
Creator III
Creator III
Author

pls find the attachement

Not applicable

I understand, that you have problem with total result of Expected Claim ...

i added partial results, and they looks ok.

Look:

santharubban
Creator III
Creator III
Author


thanks Dariusz... Can you pls tell me how to added Partial results.

Not applicable

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