Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I don't know how to use the variables well.
I have defined them this way:
vGG_DataOfferta = DayNumberOfYear(DataOfferta.autoCalendar.Date)
vGG_oggi = DayNumberOfYear(Today()).
I wrote:
Count ({$ <vGG_DataOfferta = {"<$ (vGG_oggi)"}>} [Serial Client])
but it produces an incorrect result.
Who can help me?
The left part of a set analyses matching must be a native field and not an expression. This means you need to create the DayNumberOfYear() within your calendar and then you could use:
Count ({$ < FieldDayNumberOfYear = {"<$(=vGG_oggi)"}>} [Serial Client])
- Marcus
Gabriele,
Why not use:
vGG_DataOfferta = DataOfferta.autoCalendar.Date
vGG_oggi = Today()
Count ({$ <vGG_DataOfferta = {$(vGG_oggi)}>} [Serial Client])
Having the DayNumberOfYear is just adding extra work to the set analysis.
Try that and if that doesn't work please let me know what the result is and what you're expecting.
Kind regards,
Yogi Achilleos
Hello.
I need to do evaluations for different years, up to the same day today, namely:
2019/01/01 - 2019/06/03 -> count ([Serial Client])
2018/01/01 - 2018/06/03 -> count ([Serial Client])
2017/01/01 - 2017/06/03 -> count ([Serial Client])
Any suggest for it?
The left part of a set analyses matching must be a native field and not an expression. This means you need to create the DayNumberOfYear() within your calendar and then you could use:
Count ({$ < FieldDayNumberOfYear = {"<$(=vGG_oggi)"}>} [Serial Client])
- Marcus
Perfect, thank you!!