Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i need to calculate the sum of an import in a time window of 30 days, that user can choose clicking on the date.
So i have to click on one day and it should calculate the sum of these values in case the field is ACQ/VIN= 'ACQUISTO' in the previous 30 days.
How can i do it?
Perhaps this?
Sum({<ACQ/VIN= {'ACQUISTO'}, DateField={">=$(=Date(Max(DateField-30),'DateFormat'))<=$(=Date(Max(DateField),'DateFormat'))"}>} Value)