Setanalyis help

[Krish2459_58]

Hi,

I need help to implemet the setanalyis logic for the below scenarios which calculate the sum(sales)

Property Data Type	Lease Data Type	LRR Data Type	Sublease Data Type	SLRR Data Type
Current	-	-	-	-
Current	Current	-	-	-
Current	Current	Current	-	-
Current	Current	-	Current	-
Current	Current	Current	Current	-
Current	Current	Current	Current	Current

[anat]

Can you elaborate bit more about your requirement. 

How you want to calculate sales, based on which logic? 

[Krish2459_58]

Hi,

It's not sales I need to get count of Property ID's.

Please check the output required column.

Property Data Type	Lease Data Type	LRR Data Type	Sublease Data Type	SLRR Data Type	Output required
Current	-	-	-	-	count(properties) where len(property data type)>0 and remaining all len()=0
Current	Current	-	-	-	count(properties where len(property data type)>0 and len(lease data type)>0 and remaining all len()=0
Current	Current	Current	-	-	"
Current	Current	-	Current	-	"
Current	Current	Current	Current	-	"
Current	Current	Current	Current	Current	"