Group footer Sum

Mario9a

Hi

How to add calcul iside Sum formula?


I will like to add Gst or % in my group sum

the base formula is total:[(SUM(<frxDBDataset1."D_EXTENS">))] is good for colum total if I will add 10% at this total

my formula is [(SUM(<frxDBDataset1."D_EXTENS*1.1">))]

I have error inside my formula

Thank you for your help

Mario

gpi

Use
[SUM(<frxDBDataset1."D_EXTENS"> * 1.1)]

Mario9a

Thank a lot

It possible to replace 1.1 with a variable

ex: [(SUM(<frxDBDataset1."D_EXTENS">*TPS))]

Thank again


Mario

gpi

[SUM(<frxDBDataset1."D_EXTENS"> * <TPS>)]

Mario9a

Thank you

Just information


How to config variable TPS in Delphi for calcul inside my report


ex: in my prog


..


var
tps : real;

begin

tps:=0.05;

..........


how to transfert in fastreport


Thank you


Mario

gpi

frxReport1.Variables.Variables := tps;

Mario9a

Thank you

I have error when I test

error message : Sysmemo6.error in expression 'undeclared identifier : 'tps'

my method is inside delphi XE2


var
variable: tfrxvariable;

begin

variable:= frxReport1.Variables.Insert(1);
variable.name:='TPS';
variable.Value:= 0.05;

my formule inside frxreport1 is

[(SUM(<frxDBDataset1."TOTAL_CARB">*tps))]


thank you

Mario

gpi

Use in Delphi:

frxReport1.Variables.Variables := tps;

in report

[SUM(<frxDBDataset1."TOTAL_CARB"> * <tps>)]

Mario9a

Hi

Sorry I have the same problem with your anwser.

frxReport1.Variables.Variables := tps;


The variable tps is numeric(real) the value for tps is 0.05 for 5% tax


I don't find my problem

Thank you for your help


Mario

Mario9a

Thank you


I find my problem because I dont create my variable inside my frxreport


My problem is Ok


I very apreciate your help!!

thank a lots

Mario