Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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!
try this
=count({<Year(date([Fecha de Entrada]))={'$(=Year(Today())'}>} [Línea de ped de Compra])/count(DISTINCT(Month(date([Fecha de Entrada]) )))
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
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