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.
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
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
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
Option 2:
Using XLS forms
See a sample of the attached XLS form that you can use to adapt your question.
a758rKW44YQY69M4sk9qJN.xlsx (6.0 KB)
Stephane
1 Like
