Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please suggest any other way to simplyfy the the below setanalysis.
//gives properties with no leases
Avg(
{$-<[Lease Data Type]={"*"}>}
[Property Code])
+
//gives properties with leases but only by current lease data type with Rent Reviews and no Subleases
Avg(
{<
[Lease Data Type]={'Current'},
[Property Data Type]={'Current'},
[LRR Data Type]={'Current'}>}
{$-<[Sublease Data Type]={"*"}>}
{$-<[SLRR Data Type]={"*"}>}
[Property Code])
Thanks..
Try this
Avg(
{<
[Property Data Type] = {'Current'},
[LRR Data Type] = {'Current'},
[Lease Data Type] = {"*"} - {'Current'},
[Sublease Data Type] = {"*"},
[SLRR Data Type] = {"*"}
>} [PropertyCode]
)