1

I'm trying to insert values in a tabla with values inside, like this table:

enter image description here

If you look at the column "202001" and row 22 at the end, it is null, so I want to insert manually any value. It is null because that value it's not inserted to the database yet.

The expression I have is Sum([SH_historico_1.MONTO]/1000000) (Mounts..)

Any ideas? maybe with that SUM and then concadenate

Sebastián
  • 437
  • 5
  • 19

1 Answers1

0

Please try:

Alt(Sum([SH_historico_1.MONTO]/1000000),0)

where 0 is as you say "any value". ALt function return first numeric value. So when your function will not return any number, another number is used.

Hubert Dudek
  • 1,666
  • 1
  • 13
  • 21