calulate where? price tva

mrnice

Hello everybody i come from rave report and try FastReport.

i have a query with total price and price without taxe et i want total taxe, how calculate that, i don't find what write in my memoview

there is my two values
[Query."INVOICE_PRICE_HT"] [Query."INVOICE_PRICE_TOTAL"]
i have tried ([Query."INVOICE_PRICE_TOTAL"]-[Query."INVOICE_PRICE_HT"]) and lot others without success.

i'tried with code too:

var
TVA:Curency;
begin
frxReport.Variables[' ' + 'Others'] := Null;
TVA:=            Currency(FieldValues['INVOICE_PRICE_TOTAL']) - Currency(FieldValues['INVOICE_PRICE_HT']);
        frxReport.Variables['TVA']:=         TVA;

and in a memoview in report [TVA] say don't finded.

thanks for your help.

gordk

([Query."INVOICE_PRICE_TOTAL"]-[Query."INVOICE_PRICE_HT"])
brackets in wrong place

[(<Query."INVOICE_PRICE_TOTAL">-<Query."INVOICE_PRICE_HT">)]

use the expression builder when building expressions it will get them right for you.

mrnice

ok, thanks you. i understand better now how that work.