Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to calculate values from the past up to the date I selected.
EX1 If Select date 04/05/2023 will calculate from past to 04/05/2023 OR
If Select date 03/01/2023 will calculate from past to 03/01/2023
The code used but the value is invalid.
Sum({<DATE = {'>=01/01/2012'},> }TOTAL Retest *Testing)
I want the red date to change according to the selected date.
I want to calculate values from the past up to the date I selected.
Invalid, value is 0
I want to calculate data from the past to a selected date.
Sorry, try this way:
sum({$<Date={"<=$(=max(Date))"}>} your measure)