setanlysis error

[Krish2459_58]

Hi ,

I'm getting the expression error for below logic. ANy help?

Avg({<[Lease Data Type]={'Current'},[Property Data Type]={'Current'},[LRR Data Type]={'Current'},{$-<[Sublease Data Type]={"*"}>},{$-<[SLRR Data Type]={"*"}>}>}[Property Code])

[F_B]

There's something odd in this part of your expression:

Avg({<[Lease Data Type]={'Current'},[Property Data Type]={'Current'},[LRR Data Type]={'Current'},{$-<[Sublease Data Type]={"*"}>},{$-<[SLRR Data Type]={"*"}>}>}[Property Code])

[Rohan]

Hi @Krish2459_58 ,

Try something like this  :

Avg({<[Lease Data Type]={'Current'},[Property Data Type]={'Current'},[LRR Data Type]={'Current'}>+
$-1<[Sublease Data Type]={"*"}>+$-1<[SLRR Data Type]={"*"}>} [Property Code])

Regards,

Rohan.