Search DaniWeb - grandtotal

PHPExcel Grandtotal Error 8 Years Ago by ehpratah …. Notice that this one has no problem dispalying trhe Grandtotal ![4.jpg](/attachments/large/3/0251bb506a72a02774b39af5f6cc20df.jpg "align-…;.$add; $basecells="H".$add; // DISPLAY THE GRANDTOTAL $objPHPExcel->getActiveSheet()->setCellValue($basecells,'Grand total'); $objPHPExcel-&… Re: how to get value (grandtotal) based on boothID 13 Years Ago by glennt …Change your select statement to this: [CODE]SELECT TOP 1 [GrandTotal],[BoothID] FROM RetailerBalance WHERE [BoothID] = boothID ORDER BY TransactionDate…REMOTE") myConnection.Open() strSQL = "SELECT TOP 1 [GrandTotal],[BoothID] FROM RetailerBalance ORDER BY TransactionDate DESC" myCommand = … Results with Subtotals and Grandtotal 14 Years Ago by RahulV … all its rows along with its subtotals and then its Grandtotal in the result returned? For Example, CustID Items Cost ExtraCharges… Tea 29.00 11.00 Subtotal: 53.00 21.00 GrandTotal: 78.00 25.00 Re: Results with Subtotals and Grandtotal 14 Years Ago by apegram … From Sales Group By CustID Union Select 'ZZZZZZZZZ' as CustID, 'GrandTotal' as Items, Sum(Cost) as Cost, Sum(ExtraCharges) as ExtraCharges….00 11.00 B1 Subtotal 53.00 21.00 ZZZZZZZZZ GrandTotal 78.00 25.00 [/CODE] how to get value (grandtotal) based on boothID 13 Years Ago by swathys … seems my code does not functioning. I still get same GRANDTOTAL even i have different BoothId in the sql. How do…("REMOTE") myConnection.Open() strSQL = "SELECT TOP 1 [GrandTotal],[BoothID] FROM RetailerBalance ORDER BY TransactionDate DESC" myCommand = New… Re: Results with Subtotals and Grandtotal 14 Years Ago by padtes … Sales Group By CustID Union Select '99' orderCol, '' as CustID, 'GrandTotal' as Items, Sum(Cost) as Cost, Sum(ExtraCharges) as ExtraCharges… Epected Primary Errors 16 Years Ago by veronicak5678 … int calculate(int){ double fee; int age; double grandtotal=grandtotal+fee; //Calculating price for #2 if (age>…Calculating for f passenger { fee=2*age; grandtotal=grandtotal+fee; printf ("%30s","The price… Problems with Switch 16 Years Ago by veronicak5678 …if (passgend==f) { fee=passage*1.5; grandtotal=grandtotal+fee; printf ("%30s","The price for…n\n"; } else { fee=2*age; grandtotal=grandtotal+fee; printf ("%30s","The price for … how to keep track of user input? 12 Years Ago by dmr1775 …, grade3 = 0, grade4 = 0, grade5, grandTotal, percentage; grandTotal = calcBasal(grade); grandTotal += calcApes(grade2); grandTotal += calcQuiz(grade3); grandTotal += calcMini(grade4); cout << "…;< "Total points: " << grandTotal << endl; percentage = ((grandTotal / 465) * 100); cout << "… Redirect pages with data 10 Years Ago by Maideen …php $groupby = ''; $displaySubTotal = FALSE; $subTotal = 0; $grandTotal = 0; $sub_balqty=0; // maideen $grn_balqty=0; // maideen …;?php $groupby = ''; $displaySubTotal = FALSE; $subTotal = 0; $grandTotal = 0; $sub_balqty=0; // maideen $grn_balqty=0; // maideen $… HELP on my codes 13 Years Ago by swathys …i would like to get the current balance -------> grandTotal = Sum(grandtotal)-(Totaldealer+Totaldealer1) Please help. [CODE]Public Class Form1… If strSQL = "INSERT INTO dbo.RetailerBalance([BoothID],[TransactionDateTime],[TransactionDate], [GrandTotal],) VALUES ('" & BoothID & "','" &… Re: Major problem with functions. Need help! 16 Years Ago by mitrmkar … show(double ticketquan, double ticketcost, double tickettotal, double grandtotal); int contyn(char msg[]); int main() { double quanmin… */ void show(double ticketquan, double ticketcost, double tickettotal, double grandtotal) { printf("\nAmount of tickets: [B][COLOR="Red"… Re: Major problem with functions. Need help! 16 Years Ago by nelledawg …while (choice == 'y' || choice == 'Y'); show2(grandtotal); return 0; } /* ================================================================ */ void heading() { system…tickettotal); } /* ================================================================ */ void show2(double grandtotal) { printf("\nGrand total of all … Totally lost in functions! 16 Years Ago by nelledawg …); void show(double ticketquan, double ticketcost, double total, double grandtotal); int contyn(char msg[]); int main() { double ticketcost, …quot;, costmin); total = total(ticketquan, ticketcost); grandtotal = grandtotal(total); show(ticketquan, ticketcost, total, grandtotal); choice = contyn("\nWould you like to… Major problem with functions. Need help! 16 Years Ago by nelledawg … void show(double ticketquan, double ticketcost, double tickettotal, double grandtotal); int contyn(char msg[]); int main() { double ticketcost,…;, costmin); tickettotal= total(ticketquan, ticketcost); grandtotal = grandtotal(tickettotal); show(ticketquan, ticketcost, tickettotal, grandtotal); choice = contyn("\nWould you like … Re: Major problem with functions. Need help! 16 Years Ago by nelledawg … double total(double ticketquan, double ticketcost) { return (ticketquan * ticketcost); } /* ================================================================ */ double grandtotal(double multtotal) { return (multtotal); } /* ================================================================ */ void show(double ticketquan, double ticketcost… Re: Major problem with functions. Need help! 16 Years Ago by nelledawg … to purchase more raffle tickets?"); show(ticketquan, ticketcost, tickettotal, grandtotal); } while (choice == 'y' || choice == 'Y'); return 0; } /* … */ void show(double ticketquan, double ticketcost, double tickettotal, double grandtotal) { printf("\nAmount of tickets: %d", ticketquan); printf… while loop problem 14 Years Ago by i_luv_c++ … charges is \$$shipping"); $grandtotal = $total + $tax + $shipping; #grandtotal $grandtotal = sprintf("%0.2f", $grandtotal); print("\nThe grandtotal is \$$grandtotal \n"); print "… Broke my page 13 Years Ago by filch …("pst").value; var ppgrndttl = document.getElementById("grandtotal").value; var stripvals=ppname+"|"+ppemail+"|"… ""; } var ttl = sttl + gst + pst; document.getElementById("grandtotal").value = price(ttl); document.getElementById("amount").value… Re: Grand Total for Form 12 Years Ago by parry_kulk … is empty make the value 0 var grandtotal = document.getElementById('grandtotal').value=='' ? 0 : document.getElementById('grandtotal').value; //get the current value in … from it and add the new total document.getElementById('grandtotal').value = parseInt(grandtotal) - parseInt(currtotal) + parseInt(document.getElementById(this.id + 'total').value… Re: Totally lost in functions! 16 Years Ago by VernonDozier …". In this function call: [code] grandtotal = grandtotal(total); [/code] you are passing the function grandtotal a parameter, but your function specification takes… no parameters: [code] double grandtotal(); [/code] So change a few variable names so that they… Re: Major problem with functions. Need help! 16 Years Ago by VernonDozier …....[/QUOTE] I would get rid of the grandtotal FUNCTION and go back to a grandtotal VARIABLE. I would initialize this variable called… right idea. Just replace line 41 with this line: [code] grandtotal += tickettotal; [/code] which I imagine was your original intent here… Retrieve data from database throught javascript & jquery 9 Years Ago by jean_5 …$table.html('</tr>'); } else { if(p === "GrandTotal" && list[j].Nome === "CountryTown"){ $…$table.html('</tr>'); } else { if(p === "GrandTotal" && list[j].Nome === "Metropolitan"){ $… Re: Please Help!!! 14 Years Ago by BobbieJean …productString; int product; double total; double grandtotal = 0; int x; productString = …= Integer.parseInt(quantityString); total = quantity * prodprice; grandtotal = grandtotal + total; JOptionPane.showMessageDialog(null, quantity + "… Re: Help with loop PLEASE! 14 Years Ago by BobbieJean …productString; int product; double total; double grandtotal = 0; int x; productString = …= Integer.parseInt(quantityString); total = quantity * prodprice; grandtotal = grandtotal + total; JOptionPane.showMessageDialog(null, quantity + "… Re: HELP on my codes 13 Years Ago by lolafuertes …] strSQL = "INSERT INTO dbo.RetailerBalance([BoothID],[TransactionDateTime],[TransactionDate], [GrandTotal],) VALUES ('" & BoothID & "','" &…MM-dd") & "', " & (GrandTotal - (Dealer + Dealer1)).ToString.Replace(System.Globalization.CultureInfo.CurrentUICulture.NumberFormat.… Re: Major problem with functions. Need help! 16 Years Ago by mitrmkar … purchases: 40.00 ... #1 in the main() function, initialize "grandtotal=0" #2 Switch order of the two lines to… be like below show(ticketquan, ticketcost, tickettotal, grandtotal); choice = contyn("\nWould you like to purchase more raffle… Confirmation Failing 14 Years Ago by kahaj … = quant * productValue * TAX_RATE; double grandTotal; //determine whether or not 5% discount … if (totalAmountDue >= 100) grandTotal = totalAmountDue * .95; else { grandTotal = totalAmountDue; } //give total … Total of 3 Newb Questions on This Code... 14 Years Ago by kahaj … = quant * productValue * TAX_RATE; double grandTotal; //determine whether or not 5% discount … if (totalAmountDue >= 100) grandTotal = totalAmountDue * .95; else { grandTotal = totalAmountDue; } //give total … Please Help!!! 14 Years Ago by BobbieJean … String quantityString; String productString; int product = 0; double grandtotal = 0; int quantity = 0; productString = JOptionPane.showInputDialog…JOptionPane.ERROR_MESSAGE); } double total = quantity * prodprice; grandtotal = grandtotal + total; JOptionPane.showMessageDialog(null, "The total amount…