Range between two Date - Set Anlaysis syntax

george456 — Mon, 17 Feb 2025 14:11:12 GMT

Dear Community

The following syntax is not behaving as excepted:

RangeSum(Above(Sum({<_Date={">=$(vMaxMonth)<=$(vDataDateAS)"}>} Tonnage),0, RowNo())).

In short I only want accumulative sales data between the begin of month which is vMaxMonth and the most recent day sales

I am still getting sales for the days where there are no sales ( Future). The graph should stop on the 16th

Please can you help

Thanks

Re: Range between two Date - Set Anlaysis syntax

MatheusC — Mon, 17 Feb 2025 14:36:46 GMT

Hi, try this:

if(FieldDay>$(=Date(today()-1,'DD')),null(),

RangeSum(Above(Sum({<_Date={">=$(vMaxMonth)<=$(vDataDateAS)"}>} Tonnage),0, RowNo())))

- Regards, Matheus

topic Range between two Date - Set Anlaysis syntax in App Development

Range between two Date - Set Anlaysis syntax

Re: Range between two Date - Set Anlaysis syntax