3 Replies Latest reply: Apr 26, 2017 8:09 AM by Coffi AZIAKOU RSS

    Can someone help me ???

    Coffi AZIAKOU
      Avg({$<[Type Facture]={'Avoir'},
      ([Fact. Mt MO]
      + [Fact. Mt D]
      + [Fact. Mt RF]
      + [Fact. Mt FV]
      + [Fact. Mt FA]
      + [Fact. Mt FD]
      + [Fact. Mt A]
      ) = {">=$(=vMt_FT_Min) <=$(=vMt_FT_Max) >=$(=vMt_FT_Max_1) <=$(=vMt_FT_Min_1)"}

          >}

      [Fact. Mt MO]
      + [Fact. Mt D]
      + [Fact. Mt RF]
      + [Fact. Mt FV]
      + [Fact. Mt FA]
      + [Fact. Mt FD]
      + [Fact. Mt A]

      )

       

      This instruction is not working. Can someone urgently help me ?

        • Re: Can someone help me ???
          Sunny Talwar

          This instruction is not working. Can someone urgently help me ?

          When you say not working, what is the issue? Error? Incorrect result? Something else? Can you share what it should do and what it is doing for you?

          • Re: Can someone help me ???
            Vineeth Pujari

            You cannot have evaluations on the Left side of the Equal sign, you probably need to create a new field that totals all of these fields which you can refer in set analysis

             

            Avg({$<[Type Facture]={'Avoir'},
            ([Fact. Mt MO]
            + [Fact. Mt D]
            + [Fact. Mt RF]
            + [Fact. Mt FV]
            + [Fact. Mt FA]
            + [Fact. Mt FD]
            + [Fact. Mt A]
            ) = {">=$(=vMt_FT_Min) <=$(=vMt_FT_Max) >=$(=vMt_FT_Max_1) <=$(=vMt_FT_Min_1)"}

                >}

            [Fact. Mt MO]
            + [Fact. Mt D]
            + [Fact. Mt RF]
            + [Fact. Mt FV]
            + [Fact. Mt FA]
            + [Fact. Mt FD]
            + [Fact. Mt A]

            )