Issue with sum, count,etc.

[andrespa]

Hi, I have a rare issue that can't resolve. I have data in one table but when I tried to do a simple sum (or any other aggregation formulae) it doesn't work.

Anyone knows why is this possible?

Best regards,

Andrés

[andrespa · Accepted solution]

Done, it was an issue with the data model. A circular reference between two fields.

[Anonymous]

may be Format of Amount Field is not a number...

Can you try like:

=sum(num(Amount))