FiveTech Software tech support forums

... escrito en lenguaje Harbour que combina 90 números, sin repetición, en una matriz de tres números, que respetan 4 posibilidades, es decir, suma ciclométrica, distancia ciclométrica, suma matemática y distancia matemática y que puede seleccionar el usuario una de las 4 posibilidades? Can ...

... https://i.postimg.cc/jqhPpc8D/Cerchio-Ciclometrico.gif The fundamental notions of cyclometrics, essential to know, are: distance, sum, midpoint and the related specific glossary. As it is easy to understand, by joining two or more points on the circumference we obtain different ...

... cQuery += "DATEDIFF('"+dHoy+"', Fac.fecha_vencimiento)," cQuery += "Fac.monto, " cQuery += "(SELECT SUM(monto_pago) FROM "+cT_Pagos+" WHERE codigo_cliente=Cli.codigo_cliente AND numero_documento=Fac.numero_documento) AS nPagos , " cQuery ...

Hola amigo, gracias por responder. No es esa la columna que me da error, es la que tiene la subconsulta, "Select sum(...." es alli donde esta el problema. Con AS y sin AS se presenta el problema. Si lees el hilo completo, el mismo Mr rao me dice que puedo hacer el calculo ...

... because I'll explain for example if we analyze the sequences 1-2 adds up to 3 this when it comes to sequences with two numbers 1-2-3 the minimum sum is 6 this when it concerns the sequences with three numbers if the user changes and puts 1 the procedure will never be able to create an array in ...

... Calc_Ambi_Sum_dist(n1,n2,nTipo)//---------------------------------------   local nNum:=0   local nTemp:=0   Do case      case nTipo= 1 // suma ciclométrica      ok          nTemp:= n1+n2          If nTemp > 90            nTemp:= ntemp-90      //el exterior 90          Endif       case ...

... NIL// FIN / END  Regards, saludos. your test not run the array aTmp is Empty my test https://i.postimg.cc/cJ51VwLx/r.png With the sum the nvalore must be min. 3 and not 1 sample 1+2 = 3 as you can see on picture the number 1 and 2 are repeated #include "fivewin.ch"Function ...

the total max is 391.85 is the sum of all columns I made a test but there is an error because then the 4 position it jump to 9 and I not understood why Image the second column of xbrowse it the row of scheme and the first are the columns ...

... for a sample : total price 1.20 it return me col - Row 9 --------1 11 -------1 the total max is 391.85 is the sum of all columns I made a test but there is an error because then the 4 position it jump to 9 and I not understood why https://i.postimg.cc/FsdHtDgW/mm.png ...

XBrowse does not natively support multiple totals in a single column. We need to use workaround. Please try this sample: #include "fivewin.ch"function Main()   USE CUSTOMER   DEFINE FONT oFont NAME "TAHOMA" SIZE 0,-15   DEFINE DIALOG oDlg SIZE 500,500 PIXEL TRUEPIXEL FON...

XBrowse does not natively support multiple totals in a single column. We need to use workaround. Please try this sample: #include "fivewin.ch"function Main()   USE CUSTOMER   DEFINE FONT oFont NAME "TAHOMA" SIZE 0,-15   DEFINE DIALOG oDlg SIZ...

Thank you Mr. Rao,

I have changed your advice but there is not any change.

As I said before, I should sum three condition. 1. all, 2. Header Ödeme Yeri = "Büroda", 3 - Header Ödeme Yeri = "Havale"

and I want to show three total in footer "Tutar" column.

if ! Empty( oCol := oBrw:oCol( "Tutar" ) )    oCol:nWidth := 90   oCol:nFooterType := AGGR_SUM//    oCol:nTotal      := 0//    oCol:lTotal      := .t.endif  and finally, oBrw:MakeTotals()oBr...

Hi, I want to sum one column in xbrowse. If I sum all of records, there is not any problem using below. http://www.objekt.com.tr/fwh_test/xbrowse1.png if ! Empty( oCol := oBrw:oCol( "Ödeme Yeri" ...

Considero que esta mal definida la consulta.
Para el caso de utilizar group by, necesitas indicar un campo por el que se va a resumir la consulta, ejemplo

SELECT YEAR(fecha),SUM(total) FROM facturas GROUP BY YEAR(fecha)
esto retornara las ventas totales agrupadas por año.

Saludos