Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Trying to figure out how to calculate current month processes.
expression:
=Sum({$<Status_Dash={'Completed'}, Month={"$(Month(addmonths(today(),-0)))"}>} Processed_Dash)
the return value should be 4342, but it is returning all data from "completed" in the database, including previous months.
Sunny has the right idea. However if your data crosses years you'll also want to include Year into the calculation.
LOAD
Date_Dash,
Month(Date_Dash) as Month,
Year(Date_Dash) as Year,
Program_Dash,
UOM_Dash,
Status_Dash,
Ave_Cost_Dash,
Processed_Dash
FROM [lib://AttachedFiles/OB_Summary_Data.xlsx]
(ooxml, embedded labels, table is OB_Dash_Data);
Then your expression is
=Sum({$<Status_Dash={'Completed'}, Month= {"$(=Month(Today()))"}, Year= {"$(=Year(Today()))"}>} Processed_Dash)