Yesterday, I began to set up several note with $Bill (record type is number) attribute, which presents the number I have to pay in latter days. Then I created a agent with $Balance (record type is number) attribute to sum up all children notes with $Bill attribute. I set the code in agent shown below:
- query : all
- agent action : $Balance=sum(children,$Bill)
No matter how hard I amend the code syntax, the agent’s $Balance still shows “0” in its column.
Is there any problem with my syntax? Please give me some clues to correct that, thanks.