Forum Discussion

kattlees's avatar
kattlees
Post Patron
8 years ago

Not show zero balance

I have a table that shows dates of charges and payments for an account. I have it set to count how old the account is to see people past 90 or more days and that is working fine. My problem is I can't get the zero balance accounts to not show up in the report. 

 

Measure: ARBalance = sum('Charges and Payments'[Amount])

Age Day Groups = if(V_ACCT[Age Days]<=30 && sum('Charges and Payments'[Amount]) <> 0,"0-30 Days",
if(V_ACCT[Age Days]>30 && V_ACCT[Age Days]<=60 && sum('Charges and Payments'[Amount]) <> 0,"31-60 Days",
if(V_ACCT[Age Days]>60 && V_ACCT[Age Days]<=90 && sum('Charges and Payments'[Amount]) <> 0,"61-90 Days",
if(V_ACCT[Age Days]>90 && V_ACCT[Age Days]<=120 && sum('Charges and Payments'[Amount]) <> 0,"91-120 Days",
if(V_ACCT[Age Days]>120 && sum('Charges and Payments'[Amount]) <> 0,"121+ Days ", "Paid")))))

 

See screnshot below.

Need Help

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    You should be able to filter the visual in order to remove the 0's

    • kattlees's avatar
      kattlees
      Post Patron
      8 years ago

      I "should be" is the key words there. I have tried it. Filters set are:

       

      I have the filter set to ARBalance greater than 0 or is less than 0 and have also tried ARBalance is not 0

       

      neither one removes the zero balances.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        HI kattlees,

         

        I guess your decimal value has more decimal place, maybe you can modify displayed decimal place to check your measure result.

         

        Regards,

        Xiaoxin Sheng

    • kattlees's avatar
      kattlees
      Post Patron
      8 years ago

      Not sure if it matters but some of my balances show up as ($0.00) and some show up as $0.00