Appformula computing sometimes

[jae581]

Hi Everyone, this app formula computes sometimes and sometimes not, I need to enter row by row and just edit /update to make the formula works and calculate the value:

DECIMAL(
  IF(
    UPPER(
      [orientacion]
    ) = "Norte",
    SUM(
      SELECT(
        Linea_Palma[Norte],
        AND(
          [id_lote] = [_THISROW].[id_lote],
          [linea] >= [_THISROW].[linea_inicial],
          [linea] <= [_THISROW].[linea_final]
        )
      )
    ),
    IF(
      UPPER(
        [orientacion]
      ) = "Sur",
      SUM(
        SELECT(
          Linea_Palma[Sur],
          AND(
            [id_lote] = [_THISROW].[id_lote],
            [linea] >= [_THISROW].[linea_inicial],
            [linea] <= [_THISROW].[linea_final]
          )
        )
      ),
      SUM(
        SELECT(
          Linea_Palma[numero_palmas],
          AND(
            [id_lote] = [_THISROW].[id_lote],
            [linea] >= [_THISROW].[linea_inicial],
            [linea] <= [_THISROW].[linea_final]
          )
        )
      )
    )
  )
    / [id_lote].[densidad]
)

Any ideas? The app works with a lot of records 

[Marc_Dillon]

What exactly do you mean that it sometimes doesn't compute?

[jae581]

Hi Marc, what I meant is: the column with this app formula sometimes calculate correctly, sometimes just calculate 0. But, if you just edit the row and save without change any column at all, then the value is calculated correctly. If I add 50 rows, 30 calculate the column correctly, 20 don't. Then I have to go row by row, click edit and then save, and the column will be calculated correctly. 

Thanks

[Marc_Dillon]

App Formulas only evaluate when the row is edited.

When you add 50, only 30 calculate correctly...until you re-edit the other rows... does the formula depend on all rows existing first?

Have you tried adding it as a Virtual Column?