Expand my Community achievements bar.

Summation of a group of field - Searching for a shortcut

Avatar

Former Community Member
Hi,



I'm quite new at building forms and I was wondering if there was a quicker way to make the summation of a series of fields. For example, let's say I have four numeric fields that I want to sum :



actual_budget_electricity

actual_budget_carinsurance

actual_budget_food

actual_budget_restaurant



The only way I know to do this is :



Sum(form1.subform1.actual_budget_electricity,actual_budget_carinsurance,actual_budget_food,actual_budget_restaurant)



However, I was wondering if there was a kind of "wildcard" I could use to command the form to summarize every field that starts with "actual_budget", like, for example :



Sum(form1.subform1.actual_budget[*])



Does such a thing exist?
1 Reply

Avatar

Former Community Member
Unfortunately no, actually Sum(form1.subform1.actual_budget[*]) would sum all fields in subform1 named actual_budget.



Chris

Adobe Enterprise Developer Support