Hi,
I've a condition to count the # of parts covered based on selection by the user with different date inputs. The below is the expression currently I'm using
=sum({<$(='[CMMS '&vBOH &' BOH Days]')={">=$(vStart) <=$(vEnd)"}, [Arrived Run Total]={"= Sum([Arrived Run Total])>= 0"} > + <[RunTot_Quantity]={"= Sum([RunTot_Quantity])>= 0"}>} Quantity)
But I need to add another condition to the above formula which will count the sum of parts with a given date input.
I'm trying something like this below. But not getting the expected result.
New expression added to the old formula , $(='[Shift Date]')={">=$(vStart)<=$(vEnd)"}
=sum({<$(='[CMMS '&vBOH &' BOH Days]')={">=$(vStart) <=$(vEnd)"},$(='[Shift Date]')={">=$(vStart)<=$(vEnd)"}, [Arrived Run Total]={"= Sum([Arrived Run Total])>= 0"} > + <[RunTot_Quantity]={"= Sum([RunTot_Quantity])>= 0"}>} Quantity)