I have a form with an EnumList field, to populate it Iโm using a Valid if SELECT(Table[field],[column]=โvalue1โ). This table has a number column that I want to SUM up as I select them from my EnumList. please helpโฆ
Are you trying to SUM up this EnumList columnโs value?
I donโt believe you can get a sum of the selected EnumList vales as the values are being selected. The sum will only be calculated after the user has completed their selection.
@Soldy_ALDC
Iโm afraid you cannot sum the enumlist content live whilst you are selecting items from a dropdown.
Guysโฆ if the column type is EnumList and the base type is number, you can sum your selections with a simple formula like SUM([EnumListColumn]).
@Aleksi
Yes itโs and to get a live preview of the sum whilst selecting the items could be possible with a small subset of numbers and using buttons. But it might not be so simple with a dropdown. I meant in that way when saying itโs not so possible
Wellโฆ we can just guess what the goal sould be
@Soldy_ALDC
You can see it in action in my community sample app. Just click on your name and add a record, and select numbers. You will see the sum below. I have used buttons but Iโm not so sure about the dropdown because the dropdown field will somehow curtain the sum field I believe. But of course @Aleksi might offer better solution(s).
thanks everyone, I got it to workโฆ
Virus-free. www.avg.com
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |