Pergunte aqui

Perfil de hobbit32 - atividade

2019-08-09 18:59:36 +0200 Medalha recebida  Pergunta famosa (fonte)
2019-05-02 22:44:16 +0200 Medalha recebida  Pergunta notável (fonte)
2019-05-02 22:44:15 +0200 Medalha recebida  Entusiasta
2019-05-01 21:44:02 +0200 Medalha recebida  Pergunta popular (fonte)
2019-05-01 11:06:21 +0200 Perguntou [base] user input based on dropdown

[base] user input based on dropdown Good morning, I have a table "Operations" with : ID (integer) Operation (text)

2019-04-22 11:41:55 +0200 Medalha recebida  Pergunta notável (fonte)
2019-04-21 21:40:43 +0200 Marcada como a melhor resposta Substract with decimal

Good afternoon,

I have a basic table with Crédit and Débit columns (INTEGER fields with 2 decimals).

When I sum up each column, the result is fine (I can see the right sum with decimal) :

  • 15363,51 for Crédit
  • 6672,32 for Débit

But when I substract Crédit with Débit, I get this result 869119 but I am expecting this result 8691,19. It's like the result got multiplied by 100.

image description

Does someone have an idea about the problem ? Is it a field type issue ?

Thank you for your help, Hobbit

2019-04-21 21:40:43 +0200 Medalha recebida  Acadêmico (fonte)
2019-04-21 21:40:35 +0200 Resposta comentada Substract with decimal

Thank you both of you for your answers ! @Opaque, you are right, Integers should not work but my dev skills are way too

2019-04-20 18:38:36 +0200 Medalha recebida  Pergunta popular (fonte)
2019-04-20 16:47:57 +0200 Pergunta editada Substract with decimal

Substract with decimal Good afternoon, I have a basic table with Crédit and Débit columns (INTEGER fields with 2 decima

2019-04-20 16:46:59 +0200 Perguntou Substract with decimal

Substract with decimal Good afternoon, I have a basic table with Crédit and Débit columns (INTEGER fields with 2 decima

2019-03-31 16:55:06 +0200 Pergunta comentada Extract value from cell based on regex

Good afternoon, Thank you so much for your quick answers. Both suggestions work well ! I also got a good reason to upg

2019-03-31 16:42:51 +0200 Medalha recebida  Pergunta notável (fonte)
2019-03-30 14:33:31 +0200 Medalha recebida  Pergunta popular (fonte)
2019-03-30 11:23:39 +0200 Perguntou Extract value from cell based on regex

Extract value from cell based on regex Good morning everyone, I am struggling for hours regarding what I think is a s