7 Replies Latest reply: Feb 14, 2012 2:00 AM by Celambarasan Adhimulam RSS

    Question

      Hi,

       

      I have this expression: Count(if(Round(Interval(Max(financial_date)-created_date)/30)<6,OrigCustomerNumber,0))

       

      but this is not working, how can I count the customer numbers that fulfill the if condition?

       

      Thank you!

        • Question
          Celambarasan Adhimulam

          Hi,

               You can achieve this by using sum instead of count..

               Sum(if(Round(Interval(Max(financial_date)-created_date)/30)<6,1,0))

           

          Hope it helps

           

          Celambarasan

            • Question

              another question sir,

               

              I have a calculated dimension:

              =if((Year(ProductCreatedDate)=$(vMaxFinYear) and (ProductCreationMonth= $(vCurrMonth)) ) and item_type='Sales Inventory',item_description)

               

              my variable $(vCurrMonth) contains different months depending on the selections made by the user.(can be multiple)

               

              $(vCurrMonth) = 'Jun' OR 'Jul' OR 'Sep'

               

              but this is not working, why? please do help me on this.