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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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