Finding the sum

[joshrussin]

I am trying to get the result of

Sum(Processed_Dash * Ave_Cost_Dash)

When Date_Dash = today() & Status_Dash = 'WIP'

This is what I am trying

(Sum({$<Date_Dash={"$(=FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays)))"}, Status_Dash={'WIP'}>} Processed_Dash))

*

(sum({$< Status_Dash={'WIP'}, Date_Dash={"$(=FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00')-1,1,$(vHolidays)))"}>} Ave_Cost_Dash))

The correct result is 195,159

I am getting the result of 8,159,732

[aarkay29]

Try This

(Sum({$<Date_Dash={"$(=FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays)))"}, Status_Dash={'WIP'}>} Processed_Dash*Ave_Cost_Dash))

[Kushal_Chawda · Accepted solution]

try this

Sum({$<Date_Dash={"$(=date(FirstWorkDate(ConvertToLocalTime(now(), 'GMT-05:00'),1,$(vHolidays))))"}, Status_Dash={'WIP'}>} Processed_Dash*Ave_Cost_Dash)