Range between two Date - Set Anlaysis syntax

[george456]

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

[MatheusC]

Hi, try this:

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

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


- Regards, Matheus