Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
my expression below isn't working when I try to add a condition. Please where is my mistake?
WORKING
=aggr(sum(building),Date)
ERROR:
sum(Aggr(If(growthdate=builddate,building),Date))
Thanks
Without knowing too much, may be this:
=Sum(Aggr(If(growthdate = builddate, Sum(building)),Date))
I think you should try this:
Aggr( Sum( If( growthdat=builddate, building ) ) , Date )
Without knowing too much, may be this:
=Sum(Aggr(If(growthdate = builddate, Sum(building)),Date))
Aggr( Sum( {<UniqueID={"=growthdate=builddate"}>} building ) , Date )
I don't know which field in the table that contains the field building that might qualify for a unique row id. But I just called it UniqueID and you have to replace it accordingly.