How to sum up products of sale items, e.g.: ${unit price} * ${quantity}

User Support Form Building
, , ,
1

Hi All,
I need your help on how to sum up the products of sale items.
e,g.: Unit_price x quantity of more than one items.
@Kal_Lam , for your attention please.

2

Hi @emaford
Welcome to the community forum. I would like to recommend the following articles.

https://support.kobotoolbox.org/calculate_questions.html

https://support.kobotoolbox.org/advanced_calculate.html

Kindly go through it and come back with any questions if you don’t find a solution.

Stephane

1 Like
3

Thank you @stephanealoo. I will get back to you as soon as I go through the articles.

1 Like
4

Hi @stephanealoo, @Kal_Lam
I would like the following to happen as in the case of calculating total quantity of items sold:
e.g.: 1. unit_price x qty = amt
2. unit_price x qty = amt …etc

and then find the total amt, calculate the GST, Discount and give the Net amt for sale. I am new so the system is not allowing me to send the file. I understand the articles you sent to me. But, my quest is to do sum total of sale items in a repeat group. Just image what happen at the counter when at a supermarket. It’s something like that!

1 Like
5

Hi @emaford
Let us say that you have your questions as Q1= Unit Price and Q2= Quantity. All these are within the repeat groups. I would suggest that you do the following.

Option 1:
Using form builder

image
image664×640 17.8 KB

Option 2:
Using XLS forms

image
image1061×310 9.22 KB

See a sample of the attached XLS form that you can use to adapt your question.
a758rKW44YQY69M4sk9qJN.xlsx (6.0 KB)

Stephane

1 Like
6

Thank you very much for your support @stephanealoo.

2 Likes