I tried few syntax from google but getting blank result, anyone will help me with correct syntax for this logic.
We need more details to assist.
Basically, for-each whatever [account=77000]
end for-each
sum(salary).
Rgds,
Kevin
Yes, I want to get the sum(salary) for account range between 10000 and 29999 in excel templete. how do I achieve this logic
Best to do that in the data model, so you can display tabular data using a template.