filter date in set analysis

[Anonymous]

Hi guys,

          I have this expression inside an textfield:

=num(Sum({<date = {$(v_max_date)}, kind = {1}>}price), ' #.##0,00 €')

and the expression return me this error:

Error: Error in set modifier ad hoc element list: ',' or ) expected

but I don't understand where I've to add ',' or )

I've define v_max_date in this way =max(date)

Thanks.

[fvelascog72]

Hi,

Try with:

=num(Sum({<date = {'$(v_max_date)'}, kind = {1}>}price), ' #.##0,00 €')

Saludos.

[Anil_Babu_Samineni]

I think yours is make sense. What is the wrong?

=num(Sum({<date = {$(=v_max_date)}, kind = {1}>}price), ' #.##0,00 €')

OR

=num(Sum({<date = {'$(v_max_date)'}, kind = {1}>}price), ' #.##0,00 €')

[shiveshsingh]

PLease try this

=num(Sum({<date = {"$(v_max_date)"}, kind = {1}>}price), ' #.##0,00 €')

[Anonymous]

no one works, i've add the attachment at the main question

[sunny_talwar · Accepted solution]

Try this

=Num(Sum({<date = {"$(=$(v_max_date))"}, kind = {1}>}price), ' #.##0,00 €')

[Anonymous]

Thanks a lot