Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
this formula seems not to work and I do not find my error. I was trying to count those orders where there is only one order position. Can you help me? 🙂 Thanks in advance!
Count({<PeriodMath={'>=$(vMinPeriodYear2)<=$(vMaxPeriod2)'},Sum(Count(POSITIONNUMBER)={1})>}ORDERNUMBER)
Hi!
In set analysis you have to write sets for fields in your data model. You can not use
Sum(Count(POSITIONNUMBER)={1}
because "Sum(Count(POSITIONNUMBER)" is not a field. You may use something like
Count({<PeriodMath={'>=$(vMinPeriodYear2)<=$(vMaxPeriod2)'}, ORDERNUMBER = {"=Count(POSITIONNUMBER) = 1"})>} ORDERNUMBER)
Hope it helps!
Jaime.
Hi!
In set analysis you have to write sets for fields in your data model. You can not use
Sum(Count(POSITIONNUMBER)={1}
because "Sum(Count(POSITIONNUMBER)" is not a field. You may use something like
Count({<PeriodMath={'>=$(vMinPeriodYear2)<=$(vMaxPeriod2)'}, ORDERNUMBER = {"=Count(POSITIONNUMBER) = 1"})>} ORDERNUMBER)
Hope it helps!
Jaime.