Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to backlog some data and only have the value total. I am trying to write an equation that will allow me to add a total revenue to the revenue I have accumulated by area. The equation I have for that is this:
Sum({$<Status_Dash={'Completed'}, Year = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays))))"}>} (Ave_Cost_Dash * Processed_Dash))
I simply want to add revenue from Jan, Feb, Mar, Apr, May from this year to this equation.
So how can I add
if current year is equal to 2017
then add total_revenue from jan, feb, mar, apr, may in 2017.
I am trying to add this so I won't have to go back at the beginning of next year and take out those from all my expressions.
Seems like you are trying to accumulated Sum? May be try using The As-Of Table