Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Try this
=Sum({<DocDate={'$(=SelectDate)'}>} Amount)
Regards,
Jagan.
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
Jagan,
Still 0 value
-H
Sok,
0 value too. And yes, SelectDate is a variable. SelectDate=Max(DocDate) and DocDate is a date format.
-H
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
Sok, Jagan - Thank you so much. It work.
-H