topic The column must not influence the rows in App Development

The column must not influence the rows

JFaucher — Thu, 20 Mar 2025 14:24:26 GMT

I have a table with several columns, and one column shows the difference between today's amount and the amount one year ago. This calculation shows rows with items opened last year. I'd like this column not to affect the lines displayed, as I don't want them to show data from a year ago, but current data. Do you know how I can set this up?

Re: The column must not influence the rows

Clement15 — Thu, 20 Mar 2025 14:46:17 GMT

Hello,

Sorry, it's in French, but here's an example that works. You need to use an aggr and set analysis

sum({<Année={"$(=max(Année))"}>}aggr(Sum({<Année={"$(=max(Année))"}>}FlagLancement)-Sum({<Année={"$(=max(Année)-1)"}>}FlagLancement),Organisation))