topic Re: how to sum values from a date that also did have values for another date in App Development

how to sum values from a date that also did have values for another date

Alfovic — Sat, 16 Nov 2024 05:37:52 GMT

Hi everyone,

i´d like to know if it is possible if you have a table with a column for :

could you sum the values as of an specific date and category where also those values for those categories also existed for another specific date?

for example: sum all values of categories "C" as of "01-05-2019" that existed by "01-04-2019"?

any help would be greatly appreciated!

Channa — Tue, 11 Jun 2019 00:55:30 GMT

=Aggr(Sum(Value),Category,Date)

Alfovic — Tue, 11 Jun 2019 01:00:00 GMT

Thanks Channa,
tried "sum(aggr(sum({<date= {"$(vMaxDate)"}>}value), category,date))"
but got the sum of the max date for all categories

Channa — Tue, 11 Jun 2019 01:34:22 GMT

you can work with P()

it will help with Categories exist only max date

try the P() and E()