topic Re: Function to aggregate columns in App Development

Function to aggregate columns

MadKow19 — Mon, 28 Mar 2022 09:16:46 GMT

Hi,
I need help in defining an aggregate function. Database, contains fields:

load

DATE,
BANK NAME,
AMOUNT
[...]
from [...]

I create a table in which the columns are "Date", the rows are "BANK NAME".

I want to have a second column to sum up the amount of the previous three months.

The RangeSum(Above(..)) function sums my rows, how do I refer to the columns?

Or — Mon, 28 Mar 2022 13:20:39 GMT

Have a look at using the Before() and/or After() functions within your rangesum instead of Above() / Below()

MadKow19 — Mon, 28 Mar 2022 13:35:33 GMT

You're wonderful 🙂 Thank you, it works 🙂
I am a beginner and there is a lot ahead of me ....