Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !!
Hi,
Try below query.
sum ( {$<Is_Current={1} ,Current_ConstructionStage={">=7<42"} >} HousingUnits )
Hi,
Try below query.
sum ( {$<Is_Current={1} ,Current_ConstructionStage={">=7<42"} >} HousingUnits )
Thank you Payal - GREAT HELP , didn't knew that QV can understand something like >=7<42 ...