Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Ls,
I want to use the Today() function to show textual notifications (field name: [Report]). There are a lot of explanations for Count, Sum etc with Today() but i dont need to sum/count something just show notifications made today.
=[Report] if (<{DayStart=(Today())}>) or something like this????
Thank you in advance for any help!
Do you only have a single Report value for every DayStart? If you do, try this
Only({<DayStart = {"$(=Date(Today()))"}>} Report)
Dear Sunny,
For some reason this does not seem to work. The field contains text lines which can very in amount every day. It is data processed by an app. People can make a notification about a situation. So one day there can be 1 notification and the other day maybe 10. I have included an example (see file).
In simple terms : show me the reports which are sent with today's date
Could you pls have a second look? really appreciated!
Kr Jeroen
And show them where exactly? In a KPI object or a chart?
Dear Sunny,
Either in a table or text box, thx
Can you check if this works
Concat(DISTINCT {<DayStart = {"$(=Date(Today()))"}>} Report, ', ')
If it doesn't, would you be able to provide a sample to show what you have and what you expect to see as the output?