Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to figure out a way to pull the total processed for each month.
LOAD
Date_Dash,
Month(Date_Dash) as vLM,
Year(Date_Dash) as vLY,
MakeDate(year(Date_Dash)) as vCY,
MakeDate(month(Date_Dash)) as vCM,
Program_Dash,
UOM_Dash,
Status_Dash,
Ave_Cost_Dash,
Processed_Dash
Currently have this in my script to attempt the MakeDate for the month and year.
Attempting this equation to retrieve the data for a specific month in the current year.
=Sum({$<Status_Dash={'Completed'}, vCM = {"$(=Month('7'))"}, vCY = {"$(=Year(Today()))"}>} Processed_Dash)
I passed the 7 to try and retrieve July's data. Just returns a 0.
Any suggestions?
Try like this
LOAD
Date_Dash,
Month(Date_Dash) as Month,
Num(Month(Date_Dash)) as MonthNum,
Year(Date_Dash) as Year,
MakeDate(year(Date_Dash)) as vCY,
MakeDate(month(Date_Dash)) as vCM,
Program_Dash,
UOM_Dash,
Status_Dash,
Ave_Cost_Dash,
Processed_Dash
and then this
=Sum({$<Status_Dash={'Completed'}, MontNum = {7}, Year = {"$(=Year(Today()))"}>} Processed_Dash)
Note: I have changed your field names from vblahblah to Month and Year because v is usually used for variables. By using v as a field name, you are probably going to confuse other developers and/or people on the community making them think that vblahblah is a variable.
Try like this
LOAD
Date_Dash,
Month(Date_Dash) as Month,
Num(Month(Date_Dash)) as MonthNum,
Year(Date_Dash) as Year,
MakeDate(year(Date_Dash)) as vCY,
MakeDate(month(Date_Dash)) as vCM,
Program_Dash,
UOM_Dash,
Status_Dash,
Ave_Cost_Dash,
Processed_Dash
and then this
=Sum({$<Status_Dash={'Completed'}, MontNum = {7}, Year = {"$(=Year(Today()))"}>} Processed_Dash)
Note: I have changed your field names from vblahblah to Month and Year because v is usually used for variables. By using v as a field name, you are probably going to confuse other developers and/or people on the community making them think that vblahblah is a variable.