Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
Have you ever used an expression as a "field" to be calculated from a set analysis? It would be like this:
=(Avg({$<PeriodField = {'$(=$(v_Param))'}, FieldA = {'A'}>} (Floor(MonthEnd(MakeDate(Year, Month)))-[DateFieldB])/(36525/100))) |
Is there anything I would need to be careful with when using this kind of expressions?
Thanks for your help
Sergio
Hi
I see nothing special in that expression - it looks like a normal set expression to me. Perhaps I have misunderstood your question.
Jonathan
Hi Jonathan,
I just wanted to make sure I wasn't doing anything strange. According to your answer, I doesn't look like that.
Thanks so much.
Sergio
Hi,
Not sure what you are trying to achieve, but I noticed you are using the AVG function without the AGGR function.
Example:
If you want to calculate the average Sales per Year, this would be the code:
= AVG(AGGR(Sum(Sales), Year))
If that does not cover your problem, could you please explain more what you are trying to achieve?