aggr expression error

[didierodayo]

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

[petter]

I think you should try this:

Aggr( Sum( If( growthdat=builddate, building ) ) , Date )

[sunny_talwar · Accepted solution]

Without knowing too much, may be this:

=Sum(Aggr(If(growthdate = builddate, Sum(building)),Date))

[petter]

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.