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 |