Format Calc error

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

TempoMin seems to be stored as text strings in the qvd. Try using the num# function when you load it:

num#(TempoMin) as TempoMin

[#3]

Yeap!

Thank you Gysbert!

Works fine now!