Skip to Content
-1
Oct 18, 2019 at 07:08 AM

Formula Giving NotAvailable

116 Views Last edit Oct 18, 2019 at 09:18 AM 2 rev

Hello, I have a requirement to have 3 columns

1. Sector(Grouping is done here on the original sector object which is Query1.Sector)
2. Measure (%CY Total Exp vs Allot which needs to be further filtered on fund value between the range 001-099)
3.Measure (%CY Total Exp vs Allot but here it needs to be further filtered on fund value between the range 100-199 or 300-399)

So i added the sector and for the first measure with range 001-099 i used this formula -: =Average(([ % CY Tot. Exp vs CY Real Allotment])ForEach([Fund - Key (Not Compounded)])ForEach([Query 1].[Sector])Where([Fund - Key (Not Compounded)]Between("001";"099")))
but it gives me #Unavailable.

for the second measure with range 100-199 or 300-399 i still wonder how to frame the formula.

Kindly help