Hi I Wanted To add up all elements in a specific columns in a DATABASE after filtering them with months and years and .
Here is my code for the total column sum which is not working :
export function button6_click(event) {
$w(‘#button7’).show();
//Add your code for this event here:
}
export function button8_click(event, $w) {
// no need to set the filter on the database since it’s still set
// how many items filtered in the dataset?
let count = $w(“#dataset2”).getTotalCount();
// get all of the items
$w(“#dataset2”).getItems(0, count)
.then((results) => {
let sumTotal = 0; // declare sum
let items = results.items;
items.forEach(item => {
// the amount is a string so convert
sumTotal = sumTotal + Number(item.amount);
});
$w(“#text15”).text = “” + sumTotal;
}). catch ((err) => {
console.log(err);
});
}
I Want to seperately add all the GSTprice and Total cost with filter and without filter(For Total accounting Details.
So How Can I Achieve that ?
Thanks In Advance