Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
When I use below expression in Pivot table Dimension (calculated dimension) I'm getting Calculation Timed out error.
aggr(if(not IsNull(AgreementNumber), (AgreementNumber)),IndividualItemNumber)
Could you please help?
Thank you 🙂
Maybe
Aggr(Only({$<AgreementNumber = {"*"}>} AgreementNumber), IndividualItemNumber)
or
Aggr(Only({$<Field = {"=Len(Trim(Field))>0"}>} AgreementNumber), IndividualItemNumber)
Maybe
Aggr(Only({$<AgreementNumber = {"*"}>} AgreementNumber), IndividualItemNumber)
or
Aggr(Only({$<Field = {"=Len(Trim(Field))>0"}>} AgreementNumber), IndividualItemNumber)
It worked. Thank you so much @BrunPierre
Hello @BrunPierre ,
Could you please help me to convert the below expression in to set expression? I need to optimize this so
AGGR(NODISTINCT(COUNT(DISTINCT(IF(L1>=2019401 AND (L2=1 AND (L3=1 OR L4>0)) AND (L5<>'M' AND L5<>'N'ANDL5 <>'O') ,IND_NUM)))), AGREEMENT_NUMBER)
Thank you:)
=Count(DISTINCT {$<L1 = {">=2019401"}, L2 = {1}, L3 = {1} > + <L4 = {">0"}, L5-= {'M', 'N', 'O'}>} IND_NUM)
Thanks,
But I'm not sure how to handle this Part (L2=1 AND (L3=1 OR L4>0) )
'+' and '*' are used in place of the OR and AND operators respectively while combining two sets.
Have you tried the above?
or perhaps
=Count(DISTINCT {$<L1 = {">=2019401"}> * <L2 = {1}> * <L3 = {1} > + <L4 = {">0"}> * <L5-= {'M', 'N', 'O'}>} IND_NUM)