Sum automatically

[hibah_alhuwayri]

Hi support,

Kindly assist with this: I would like to sum automatically when the row is selected number

I have tried various ways, but it fails.

Can anyone help me?
Thank you

[Aurelien]

Hi @hibah_alhuwayrini

Welcome to the community !

You may want to set the calculation expression in the app formula

with this following expression:

[Dashboard]+[Trunk(big car)]+[Buttons car]

Please note:
I notice your columns are type EnumList.
If the previous expression does not work, please try instead:

SUM([Dashboard])+SUM([Trunk(big car)])+SUM([Buttons car])

for reference, I suggest you have a look to:

help.appsheet.com

App Formulas and Initial Values

How you can set app formulas and initial values to dynamically assign values.

[hibah_alhuwayri]

Aurelien:

SUM([Dashboard])+SUM([Trunk(big car)])+SUM([Buttons car])

Hi @Aurelien
Thank you for your quick respon .
Unfortunately it do not work

[Aurelien]

OK, can you change it to:
SUM([Dashboard]+[Trunk(big car)]+[Buttons car])

[hibah_alhuwayri]

@Aurelien
Same proplem

[WillowMobileSys]

Make sure the base type of the EnumList columns is Number.

As noted in the comments, all of the columns are set as EnumList which means a user could select more than 1 value. Is that your Intent?

[WillowMobileSys]

I just played with an example. This works for either Enum or EnumList. Just make sure the Base Type is Number.

EnumList - View with multiple choices

EnumList - Columns

EnumList Result Expression

SUM([Number1]) + SUM([Number2]) + SUM([Number3])

---

If you DO NOT wish to allow multiple choices, change the Columns to Enum and then the expression would be:

[Number1] + [Number2] + [Number3]

[Pooja2]

use LIST(SUM(--------- it will work

[WillowMobileSys]

Not if you are trying to store a single result in a column defined as Number.

Could you have meant SUM(LIST(…)?

EDITED: I just tried SUM(LIST(…)) on the columns defined as EnumList. It doesn’t work becasue each column itself is a list.

[hibah_alhuwayri · Accepted solution]

@Aurelien @Pooja @WillowMobileSystems

Thanks a lot for help me …

The proplem is solved