Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I tried the following as a calculated dimension but its comes up as a invalid
if(sum({< Date = {">=$(vStartDate)<=$(vEndDate))"} >}[Sales])>0,
fldAccount,null())
I only want to show the Account where the sales are greater than 0.
Thanks
Hi,
You can try like this,
Dimension:
fldAccount
Measure:
sum({$<Date = {">=$(vStartDate)<=$(vEndDate))"},Sales={">0"} >}Sales)
another way u can simply create calculated dimension like below
=aggr(if(sum({$<Date = {">=$(vStartDate)<=$(vEndDate))"},Sales={">0"} >}Sales),fldAccount),fldAccount)
Thanks,
Deva
Hi,
You can try like this,
Dimension:
fldAccount
Measure:
sum({$<Date = {">=$(vStartDate)<=$(vEndDate))"},Sales={">0"} >}Sales)
another way u can simply create calculated dimension like below
=aggr(if(sum({$<Date = {">=$(vStartDate)<=$(vEndDate))"},Sales={">0"} >}Sales),fldAccount),fldAccount)
Thanks,
Deva
Hi,
I got the same kind of requirement,
can you try it below way in dimension:
If(sum({$<[Expire_Date_Contract_Validity]={'True'} >}
internal_customer_name)>0, Avg ([Start_Date_Contract_Validity]),0)+
If(Count({$<[Expire_Date_Contract_Validity]={'False'} >} %CaseId)>0,
Avg([Start_Date_Contract_Validity]), 0)
Thanks
that worked are quite well.