Set analysis with two date conditions

Husky_Bab12 — Mon, 05 Sep 2022 23:05:13 GMT

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)

topic Set analysis with two date conditions in App Development

Set analysis with two date conditions