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




      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


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



          Hope it helps



            • 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.