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

Announcements
Check out our latest virtual session where BARC Fellow, Doug Laney, highlighted the opportunities data monetization can offer enterprises. Watch here.
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
santharubban
Creator III
Creator III
Author

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

Not applicable

May you share application with sample data?

santharubban
Creator III
Creator III
Author

i have attached screen shot

Not applicable

I saw it. But i would like to look into application ....

MK_QSL
MVP
MVP

Instead of Round(YourExpression,0.01) use

Floor(YourExpression)

santharubban
Creator III
Creator III
Author

I already try, not working

MK_QSL
MVP
MVP

please upload sample apps

santharubban
Creator III
Creator III
Author

pls find attachement

sundarakumar
Specialist II
Specialist II

couldn't find any attachment. can u pls check.

-Sundar