2 Replies Latest reply: Apr 23, 2017 10:16 AM by Mohamed Azmi RSS

    Function above

    Mohamed Azmi
    Mohamed Azmi Apr 21, 2017 10:42 AM

      Hii my friends

       

      I Have problem with above I want skip Just Year='2014' and not janv/2015

       

      Thanks if someone have solution.

       

       

      Cap2.JPG

      • 87 Views
      • Tags:
        • Re: Function above
          Sandro Pividori
          Sandro Pividori Apr 21, 2017 6:47 PM (in response to Mohamed Azmi)

          Hi.

          You should create a dimension that is Month-Year or solve it in the load script.

          I do not know any other way to solve it.

           

          Regards.

          • Re: Function above
            Mohamed Azmi
            Mohamed Azmi Apr 23, 2017 10:16 AM (in response to Mohamed Azmi)

            Hi spividori

             

            I dont understand what you mean for that I think I have problem with my expresion

             

            (Sum({<Marque={'NA'}>}Qte) /above(Sum({<Marque={'NA'}>}Qte)))-1

             

            for skipped Just Year='2014'

             

             

            and for globality my function is calcul if

            year is 2014 Calcule is ('2014'/2013)-1 I use above for not calculed 2013 because I haven't

            and if year='2015'   calcul is (2015/2014)-1

            and if year='2016' calcul is (2016/2015)-1

            and if year='2017' calcul is (2017/2016)-1

             

            THANKS FORREPLY