Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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.
Hi,
Try with this,
use vCurrMonth = Concat(Distinct ProductCreationMonth,',')
Then
=if((Year(ProductCreatedDate)=$(vMaxFinYear) and SubStringCount($(vCurrMonth),ProductCreationMonth)>0 ) and item_type='Sales Inventory',item_description)
Hope it helps
Celambarasan
I think substringcount is not the one that i'm looking for because I want to show the data based on the value of vCurrMonth which might be ('Jun' or 'Jul' or 'Aug') or other months based on user selections
Hi,
What expression are you using for the variable vCurrMonth?
Celambarasan
=chr(39) & Concat(DISTINCT fin_month_name & chr(39),' or ' & chr(39))
with my current calculated dimension, it only gets the first value
Hi,
Try using match function.
=if((Year(ProductCreatedDate)=$(vMaxFinYear) and Match(ProductCreationMonth,$(vCurrMonth)) ) and item_type='Sales Inventory',item_description)
In condition we cann't compare fieldname ='jan' or 'jul because first it evaluates fieldname='jan' then it take 'jul' as separate expression.
Celambarasan