as calculated in GROUP BY TOTAL than SUM AVG MIN or MAX

Applications Grid / Reports
#1

As I can calculate two columns fields TOTAL GROUP BY as follows:

    CAMPO 1       CAMPO 2       CAMPO 3
       1000           1500          150   
       2000           2500          125

TOTALES: 3000 4000 133.33

field calculation 3 is (Field 2 / field 1) * 100, I have no problem with that because I do in the event of onrecord
what I need is how I can calculate the total “field 3” which is (Field 2 / field 1) * 100 which is the same calculation of onrecord but now need to do the same calculation in cuts GROUP BY TOTAL fields as indicated above.

I welcome your support.
Thank you.

#2

Re: as calculated in GROUP BY TOTAL than SUM AVG MIN or MAX

Hello,

Are you able to set any value to the “Campo 3” totale? Is “Campo 3” a virtual field or an actual existing field on your table?

regards,
Bernhard Bernsmann

#3

Re: as calculated in GROUP BY TOTAL than SUM AVG MIN or MAX

Field 3 is a virtual field and I can only calculate the grand total, not the TOTAL GROUP BY. in helping ScriptCase totaling macros Variables (group by) (http://downloads.scriptcase.com.br/downloads/v6/manual/es_es/webhelp/manual_mp/manual_mp.htm), supposedly the total GROUP BY as indicated the instruction manual with sum_break_balance or sum_break_parcel.

graphically explained in accompanying me.

saludos.

groupby.docx (66.9 KB)

#4

Re: as calculated in GROUP BY TOTAL than SUM AVG MIN or MAX

Hello Marce,

I have answered your PM.

regards,
Bernhard Bernsmann

#5

Re: as calculated in GROUP BY TOTAL than SUM AVG MIN or MAX

ernhard - can we know the solution ?

#6

Re: as calculated in GROUP BY TOTAL than SUM AVG MIN or MAX

The solution es:

sum_quebra_a=(sum_quebra_b/sum_quebra_c) *100

in the manual is wrong, not with the instruction “break” is to “quebra”

#7

Re: as calculated in GROUP BY TOTAL than SUM AVG MIN or MAX

Quebra is portuguese translation to break. I have contacted our development team to fix this issue.

regards,
Bernhard Bernsmann

#8

Re: as calculated in GROUP BY TOTAL than SUM AVG MIN or MAX

Try:

sum_groupby_a=(sum_groupby_b/sum_groupby_c) *100

I believe that only the manual translation is wrong.