Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN 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
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