Set analysis and expression

[#1]

Hi there,

Can someone tell me what´s going wrong with this expression? I get an ok in the expresion but is no reporting any data, although both expressions (numerator & denominator) separately give a value.

=count({<"Year([Fecha de Entrada]"={"Year(Today()"}>} [Línea de ped de Compra])/count(DISTINCT(Month([Fecha de Entrada])))

Thanks in advance and regards.

Asier

[#2]

Try something like,

count(If(Year([Fecha de Entrada])=Year(Today()), [Línea de ped de Compra]/count(DISTINCT(Month([Fecha de Entrada]))))

Hope it helps

[jerem1234]

You can't have expressions as fields in set analysis like {<year(Date) = {'2014'}>}.

Try this code:

count({<[Fecha de Entrada]={"=Year([Fecha de Entrada])=Year(Today())"}>} [Línea de ped de Compra])/count(DISTINCT Month([Fecha de Entrada]))

Hope this helps!

[#4]

try this

=count({<Year(date([Fecha de Entrada]))={'$(=Year(Today())'}>} [Línea de ped de Compra])/count(DISTINCT(Month(date([Fecha de Entrada])  )))

[#5]

Thanks all.

But with the count function at the beguining I get an error message and without it the result is - when the result should return 135.000 / 12.

With the other example I get the same result -

If I calculate both expressions separately I get the result.

Should I define variable for this?

Thanks

[#6]

Thanks all.

But with the count function at the beguining I get an error message and without it the result is - when the result should return 135.000 / 12.

With the other examples I get the same result -

If I calculate both expressions separately I get the result.

Should I define variable for this?

Thanks