topic Re: Day from Yesterday in App Development

Day from Yesterday

Controller1 — Thu, 02 Mar 2023 10:39:03 GMT

Hello,

I have a problem. My formula works for today but not for yesterday. I have already inserted -1 after day but it doesn't show me anything.
What have I done wrong?

This is my formula that works

Sum({<Tag={'$(=max(Tag))'}>}[nicht abgerechnet])

Why doesn't it work?

Sum({<Tag={'$(=max(Tag-1))'}>}[nicht abgerechnet])

Re: Day from Yesterday

marcus_sommer — Thu, 02 Mar 2023 10:52:03 GMT

Try it in this way: Sum({<Tag={"$(=max(Tag)-1)"}>} [nicht abgerechnet])

Re: Day from Yesterday

Controller1 — Tue, 14 Mar 2023 08:26:40 GMT

we tried with way

=if(ISNULL( GetFieldSelections([Tag])), Sum ( {$<[Tag] = {"$(=date(today()-1,'DD.MM.YYYY'))"}>} [nicht abgerechnet] ), sum({<Tag={'$(=Date(getfieldselections(Tag) -1))'}>} [nicht abgerechnet]) )

your way didnt´t show me the right figures. I don´t no why but thanks for your help

Re: Day from Yesterday

marcus_sommer — Tue, 14 Mar 2023 08:37:21 GMT

It wasn't obvious that your [Tag] isn't a day else a formatted date. Try it again with:

Sum({<Tag={"$(=date(max(Tag)-1))"}>} [nicht abgerechnet])

Each calculation on a field like the max() or just Field - 1 removed any formatting and returned a pure number. But within the Set Analysis the comparing happens on a string-level and therefore including the formatting which is now not matching anymore. Exceptions are a >= <= comparing which goes to the numeric values behind any format.