Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to get the maximum value on the date using Set Analysis.
first y created a variable:
Date(MAX(Date(FECHA_PL)),'DD/MM/YYYY')
the result is OK!
Then I use this variable in Set Analysis but it returns Error
---------------
it should work like this:
I tried everything and what worked for me was this
= AVG ({<FECHA_PL = {$ (= Chr (39) & Max (date (FECHA_PL, 'DD / MM / YYYY')) & Chr (39))}>} ValorIndicador)
How about this:
=Avg({<FECHA_PL = {'$(=Text(MaxFechaPL))'}>} ValorIndicator)
Try
=Avg( {<FECHA_PL = {'$(MaxFechaPL)'}>} ValorIndicador)
edit: Assuming your variable is defined with a leading equal sign.
Or just use
=Avg( {<FECHA_PL = {'$(=Date(MAX(Date(FECHA_PL)),'DD/MM/YYYY'))'}>} ValorIndicador)
May be an opening bracket after max like = Avg( {<FECHA_PL = {'$(Max(FechaPL))'}>} ValorIndicador)
Is there a fieldname MaxFechaPL, i doubt you missed a bracket here ? Correct me...
Thanks,
V.
Sorry Is MaxFechaPL is your variable name ? If Yes, follow what sunny and swuhel suggested.
it doesn´t work 😕
I tried everything and what worked for me was this
= AVG ({<FECHA_PL = {$ (= Chr (39) & Max (date (FECHA_PL, 'DD / MM / YYYY')) & Chr (39))}>} ValorIndicador)
I tried everything and what worked for me was this
= AVG ({<FECHA_PL = {$ (= Chr (39) & Max (date (FECHA_PL, 'DD / MM / YYYY')) & Chr (39))}>} ValorIndicador)