problem with set analysis

[Anonymous]

Hi community,

I have a problem with set analysis, it give me 0 where I'm sure it not the right one. Anyone help me please with this error

Sum({<DocDate={$(SelectDate)}>} Amount)

-H

[jagan]

Hi,

Try this

=Sum({<DocDate={'$(=SelectDate)'}>} Amount)

Regards,

Jagan.

[Sokkorn]

Hi H,

It look like you use variable in set analysis. Can you confirm:

1. SelectDate is a field name or variable? If variable, what is definition?

2. What is DocDate value look like? In Date format or number?

You may try Sum({<DocDate={"$(SelectDate)"}>} Amount)

Regards,

Sokkorn

[Anonymous]

Jagan,

Still 0 value

-H

[Anonymous]

Sok,

0 value too. And yes, SelectDate is a variable. SelectDate=Max(DocDate) and DocDate is a date format.

-H

[Sokkorn · Accepted solution]

Hi H,

Ok, got your point. Do this way

=Sum({<DocDate = {"$(=Date(Max(DocDate),'DD.MM.YYYY'))"} >} Sales)

Edit: you need to format date according to your DocDate field.

Regards,

Sokkorn

[Anonymous]

Sok, Jagan - Thank you so much. It work.

-H