Set Analysis Inconsiderate part of the condition.

[yanivvl0]

hi to all ,

i have Expression with SetAnalysis :

sum ( {$<Is_Current={1} ,Current_ConstructionStage={"<42"}  ,Current_ConstructionStage={">=7"} >}  HousingUnits )

while compute - i see that the Current_ConstructionStage={"<42"}  is Inconsiderate :

i expect to see 22 but it sum also the 52 HousingUnits ...

THANKS !!

[Anonymous · Accepted solution]

Hi,

Try below query.

sum ( {$<Is_Current={1} ,Current_ConstructionStage={">=7<42"} >}  HousingUnits )

[yanivvl0]

Thank you Payal - GREAT HELP , didn't knew that QV can understand something like >=7<42 ...