Hi all,
I am trying to concatenate two resident tables in one application and calculates one field based in another ones.
When I multiply the field values, the resulting ones are wrong.
I guess this is an formatting issue, cause I am using collon as decimal separator, but I am no sure that,
My regional settings are:
SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET MonthNames='jan;fev;mar;abr;mai;jun;jul;ago;set;out;nov;dez';
SET DayNames='seg;ter;qua;qui;sex;sáb;dom';
My Concatenate expression is:
TarefasFato:
LOAD
Year(%Data) AS Ano,
Month(%Data) AS Mes,
%Data AS Data,
_Tipo AS _Tipo,
#Tempo AS #Tempo,
INT_CODSIS AS CodSistema,
INT_CODMOD AS CodModulo,
INT_CODUSU AS CodExecutor,
INT_CODRSP AS CodResponsavel,
INT_NOMRSP AS NomeResponsavel,
USU_NOMUSU AS NomeExecutor,
INT_NOMSIS AS DescSistema,
INT_NOMMOD AS DescModulo,
0 AS HorasTrabalhadas,
TempoMin AS TempoMinutos,
INT_VALSAL AS #SalarioHora,
TempoMin*INT_VALSAL AS Custo
RESIDENT TempInterferencias;
CONCATENATE
LOAD
Year(%Data) AS Ano,
Month(%Data) AS Mes,
%Data AS Data,
_Tipo AS _Tipo,
#Tempo AS #Tempo,
TRA_CODSIS AS CodSistema,
TRA_CODMOD AS CodModulo,
TRA_CODUSU AS CodExecutor,
TRA_USURES AS CodResponsavel,
TRA_NOMRES AS NomeResponsavel,
TRA_NOMUSU AS NomeExecutor,
TRA_NOMSIS AS DescSistema,
TRA_NOMMOD AS DescModulo,
TRA_CODPRJ AS %CodProjeto,
TRA_CODPRJ&'-'&TRA_CODFAS AS %CodFase,
TRA_HORAS AS HorasTrabalhadas,
TempoMin AS TempoMinutos,
TRA_VALSAL AS #SalarioHora,
TempoMin*TRA_VALSAL AS Custo
RESIDENT TempTarefas;
My Error is at expression TempoMin*TRA_VALSAL and TempoMin*INT_VALSAL
For example:
TempoMin=150
#SalarioHora=42,9975
Custo=4,47890624989572
Custo Should be 6449,625, right?
I am attaching the base and resulting qvd files too
Any help will be appreciated,
Thanks in advance
