Valueloop

[#1]

Hello All,

Could you please help me with the expression below:

Sum(Valueloop(0,(Count(DISTINCT {<FirstAgent={'<>0'}>}(Agent))/Count(DISTINCT(Date))),2))

The value loop does not seem to function with "(Count(DISTINCT {<FirstAgent={'<>0'}>}(Agent)"

Any idea?

Many Thanks,

Hasvine

[sunny_talwar]

Is the number suppose to change for each dimension? If that's true, then it might not work. If it is a single number for all the dimensions, you can try this:

Sum(Valueloop(0, $(=(Count(DISTINCT {<FirstAgent={'<>0'}>}Agent)/Count(DISTINCT Date))), 2))

[antoniotiman]

FirstAgent-={0}