2 Replies Latest reply on Aug 10, 2018 6:28 AM by Jim Dehner

    Simple division, bad result

    melaniedddd

      Hi everybody,

       

      I'd like divide some values in a view (see attached) :

      - For example, the number of single product / single ID, or the MQT amount per single ID on the period...

       

      In my workbook attached, results seems good but with real datas, sum(number of product)/sum(number of Id) is not the expected result.

       

      Any idea to avoid this mistake ?

       

      Many thanks !!

       

      Mélanie

        • 1. Re: Simple division, bad result
          Zhouyi Zhang

          Hi, Melanie

           

          Which calculation is the problematic, can you give an example?

           

          ZZ

          • 2. Re: Simple division, bad result
            Jim Dehner

            Hi

             

            Not Certain I understand the calculation you are trying to do but see the attached

             

            it will return this

             

            the issues you have are 2 fold

            first I converted "Product" to a dimension - I think that it is a product number used to categorize data

            then I created 2 lod expressions

            and

             

            and then this  which looks at the total montant ht in the current period / the count 2 periods back -

            Not certain if you wanted sum() or Max() or something else

             

            Window sum is going to give you a different result

             

            Jim

             

            If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.