0 Replies Latest reply: Nov 22, 2017 12:24 PM by Hector Javier Velez Bautista RSS

    Chart Indicator

    Hector Javier Velez Bautista

      Hello,

       

      I need help with the following:

      I have in a table the people with their balances as shown in the following image:

      V1.png

      And what I want to do is to be able to tell people that their balance is greater than 0 and put it on an indicator chart as the following image shows:

      V2.png

      There he says that there are only two but there are many more people, the expression I am occupying is:

       

      Count (DISTINCT (if ((Report_AO_ENE_OCT.Subtotal) - ((GF.abonos) + (GC.ABONOS))> 0, Report_AO_ENE_OCT .Viaticante)))

       

      I also tried with the following expression but it marked me error:

       

      Count (DISTINCT (if (Sum(Report_AO_ENE_OCT.Subtotal) - (Sum(GF.abonos) + Sum(GC.ABONOS))> 0, Report_AO_ENE_OCT .Viaticante)))

       

      Any suggestions or someone who can tell me what I'm doing wrong.

       

      Thank you.