How do you use list grid to save the data into the datalist.
A form can save data and edit it when you MULTIPLY TOTALS give you an answer , but when you retrieve datalist
and edit quanity the totals come wrong with same equation e.g
bedding: price 10 qnty 10
pillow: price 5 qntity 5
covers: 8 qnty 5
you expect multiplying price*quantity all give you 165
but when you do a form grid with a listing it will add all pricing to 23 first then when you enter qnty 10 gives 230
then wen u enter pillow quantity 5 now it multiplies 230 by (adding price 10 and 5) give 230*15 =3450
problem is when you retrieve listing grid for your form grid its not multiplying row by row, but adding colums and multiplying by added column totals also
Please take note that you should create a new page instead of commenting on this page itself. On this page, click on "Add" -> "Page" next time when you are posting.
To your question, in the form you configured to point to in your Form Grid, you should add a calculation field itself to sum up the individual item. (e.g. 10 x 10 = 100, 5 x 5 = 25, 8 x 5 = 40).
Then, in the main form, use another calculation field to sum up the total of individual items (e.g. 100+25+40).
2 Comments
takudzwa madyira
How do you use list grid to save the data into the datalist.
A form can save data and edit it when you MULTIPLY TOTALS give you an answer , but when you retrieve datalist
and edit quanity the totals come wrong with same equation e.g
bedding: price 10 qnty 10
pillow: price 5 qntity 5
covers: 8 qnty 5
you expect multiplying price*quantity all give you 165
but when you do a form grid with a listing it will add all pricing to 23 first then when you enter qnty 10 gives 230
then wen u enter pillow quantity 5 now it multiplies 230 by (adding price 10 and 5) give 230*15 =3450
problem is when you retrieve listing grid for your form grid its not multiplying row by row, but adding colums and multiplying by added column totals also
Hugo
Hi there,
Please take note that you should create a new page instead of commenting on this page itself. On this page, click on "Add" -> "Page" next time when you are posting.
To your question, in the form you configured to point to in your Form Grid, you should add a calculation field itself to sum up the individual item. (e.g. 10 x 10 = 100, 5 x 5 = 25, 8 x 5 = 40).
Then, in the main form, use another calculation field to sum up the total of individual items (e.g. 100+25+40).
Good luck.
Hugo