Search found 260 matches: sum

Return to advanced search

Count xbrowse records

Hi, I have a xbrowse:

Lista40:cAlias := "ARQANO"

How I count records? I don't want the deleted ones to enter the sum.

Thanks!
by wartiaga
Thu Feb 22, 2024 11:13 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Count xbrowse records
Replies: 5
Views: 214

Re: SetDlgGradient

I have put several of my gradients into functions .. very easy to use ...

Please ensure that the sum of the first column of all sub-arrays is 1.0.
Otherwise, your examples mislead other users who are new.
by nageswaragunupudi
Fri Sep 29, 2023 1:55 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: SetDlgGradient
Replies: 10
Views: 751

Re: problem with report to excel

... Spanish, what is it for Dutch? -> 'nl' is the iso code for Dutch and Flemish. 2) Please provide translations for: SUBTOTAL( -> SUBTOTAAL( SUM( --> ??? - > SOM( TRUE --> ??? -> WAAR FALSE --> ??? -> ONWAAR Language ID = 1043 Decimal separator = , Thousands separator = ...
by bart
Mon Sep 04, 2023 5:13 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: problem with report to excel
Replies: 18
Views: 3345

Re: problem with report to excel

... this information: 1) Like 'de' for German, 'es' for Spanish, what is it for Dutch? 2) Please provide translations for: SUBTOTAL( -> SUBTOTAAL( SUM( --> ??? TRUE --> ??? FALSE --> ??? Please run the small test and let us know the results: oExcel         := ExcelObj()? ...
by nageswaragunupudi
Mon Sep 04, 2023 2:03 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: problem with report to excel
Replies: 18
Views: 3345

Filter y MakeTotals en xBrowse (to Mr. Nagues)

Hola gente, buenos días.. tengo un xBrowse donde necesito filtrar filas según una opción que tengo que a veces muestro unos datos y otras veces no. A la vez, una de mis columnas editables, cuando modifico el dato, me realiza mal la cuenta en el MakeTotals, hago lo siguiente: REDEFINE XBROWSE oBrw ID...
by TOTOVIOTTI
Mon Aug 28, 2023 1:34 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Filter y MakeTotals en xBrowse (to Mr. Nagues)
Replies: 0
Views: 182

Re: Summation by condition

Here some samples oBrw:Age:bSumCondition := { |v,o| o:Value % 2 == 1 }, ; oBrw:State:nFooterType := AGGR_COUNT, ; oBrw:State:bSumCondition := { |v,o| "A" $ o:Value }, ; oBrw:Salary:nFooterType := AGGR_SUM, ; oBrw:Salary:bSumCondition := { || .NOT. FIELD->MARRIED }, ; //oBrw[6]:sel:bSumC...
by Marc Venken
Fri Jun 02, 2023 11:55 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Summation by condition
Replies: 2
Views: 174

Re: xBrowse footer picture

Postby nageswaragunupudi » Sun May 03, 2020 6:54 am CODE: SELECT ALL EXPAND VIEW WITH OBJECT oCol :nFooterType := AGGR_SUM :cEditPicture := "€ 99,999.99" :cDataType := "N" END In case of empty arrays we need to inform the datatype of the column by setting cDatatype Or we wait fo...
by Detlef
Mon Apr 03, 2023 2:19 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse footer picture
Replies: 11
Views: 697

Re: xBrowse footer picture

I found the cause of more than 2 decimals in the footer sum.. My column value was computed by multiplying a numeric value by a val( alltrim( cValue ) ) . The xBrowse column was showing correct values with 2 decimals according to the column picture clause. ...
by Detlef
Mon Apr 03, 2023 2:07 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse footer picture
Replies: 11
Views: 697

Re: xBrowse footer picture

Postby nageswaragunupudi » Sun May 03, 2020 6:54 am CODE: SELECT ALL EXPAND VIEW WITH OBJECT oCol :nFooterType := AGGR_SUM :cEditPicture := "€ 99,999.99" :cDataType := "N" END In case of empty arrays we need to inform the datatype of the column by setting cDatatype Or we wait for...
by Marc Venken
Mon Apr 03, 2023 2:01 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse footer picture
Replies: 11
Views: 697

Re: xBrowse footer picture

:aCols[ 3 ]:nFooterType := :aCols[ 5 ]:nFooterType := AGGR_SUM Is this also hapening when you just use 1 of them ? :aCols[ 5 ]:nFooterType := AGGR_SUM and if you made 2 different with object oBrwpos and obrw.... Thanks Mac, for your idea. I just tried it but no difference. The misbehavior is still ...
by Detlef
Mon Apr 03, 2023 1:07 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse footer picture
Replies: 11
Views: 697

Re: xBrowse footer picture

:aCols[ 3 ]:nFooterType := :aCols[ 5 ]:nFooterType := AGGR_SUM

Is this also hapening when you just use 1 of them ?

:aCols[ 5 ]:nFooterType := AGGR_SUM

and if you made 2 different with object oBrwpos and obrw....
by Marc Venken
Mon Apr 03, 2023 11:23 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse footer picture
Replies: 11
Views: 697

Re: Meter con Mysql

... otra es la consultas para hacer la comparación, si es así utiliza el meter en el DO WHILE de la tabla primaria. Otro tip, es que uses la cláusula SUM de MySql para ahorrarte tiempo, solo para ahorro de tiempo. Si pudieras poner un poco de código para poder apoyarte más. Saludos
by Armando
Tue Mar 28, 2023 5:37 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Meter con Mysql
Replies: 6
Views: 588

change xbrowse footer menu

Hello everyone; I dropped by the forum in need to change standard footer menu (sum, count, ave ...) for my own and saw messages about openAI writing harbour code so I tried it. I asked: "write harbour code that modifies xbrowse footer popup menu" Here ...
by reinaldocrespo
Fri Jan 06, 2023 11:23 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: change xbrowse footer menu
Replies: 2
Views: 280

Re: chatGPT writes and executes Harbour code !!!

... in the chat ( https://chat.openai.com/chat ) and in the end I managed to find a solution for three out of 2 functions mathematical sum run ok FUNCTION somma_matematica(nvalore)    local aTmp := {} local i,j,k  FOR i := 1 TO 90    FOR j := i+1 TO 90      FOR k := ...
by Silvio.Falconi
Mon Dec 19, 2022 9:19 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: chatGPT writes and executes Harbour code !!!
Replies: 35
Views: 2726

Re: chatGPT writes and executes Harbour code !!!

... an array of numbers from 1 to 90, without repetition, in an array formed by three numbers, which respect 4 possibilities i.e. the cyclometric sum, the cyclometric distance, the mathematical sum and the mathematical distance and that the user can select one of the 4 possibilities and the value ...
by Silvio.Falconi
Wed Dec 14, 2022 8:11 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: chatGPT writes and executes Harbour code !!!
Replies: 35
Views: 2726
Next

Return to advanced search