hi,
i want a certain to auto populate itself with the total quantity based on previous cell selections i make that is lot no. and brand…here in the screenshot you can see that in pic 1 i have the data of a particular lot along with lot no., brand name, qty…
as in pic 2 when i select brand and lot no. i want the total of a prticular brand in a particular lot no. to be summed up and fill automatically…
as in the screenshot when i select lot no. 4 and brand as pink…i must get the value in qty as 103 (100+3).
what expression can help me in getting this done…!
PIC 1
PIC 2
Solved! Go to Solution.
There will be bunch of workaround to achieve the same goal and task.
For instance, you will use PIC 2 table as sort of “calculator” to dynamically calculate the total, based on the user selections. To do that, follow those steps.
Your user visit the detail view you created on step 7, and they select out of dropdown, then dynamically calculate value. but this PIC2 should be shared across the users. So if you want to keep this table assigned to each users, then turn on private mode on that table.
There will be bunch of workaround to achieve the same goal and task.
For instance, you will use PIC 2 table as sort of “calculator” to dynamically calculate the total, based on the user selections. To do that, follow those steps.
Your user visit the detail view you created on step 7, and they select out of dropdown, then dynamically calculate value. but this PIC2 should be shared across the users. So if you want to keep this table assigned to each users, then turn on private mode on that table.
i had set column type of qty to number …i got error.
when i set to list type i m getting error as in pic below.
is there a work around for this
It must be number type instead of list.
i am still getting error when type set to number as in screenshot below
You need to warp expression by sum
could you pls elobarate and help by writing the expression in full
It is in there in my previous post.
Thanks…for the quick response…your solution worked…
Great.
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |