Optime expression

AppSheet AppSheet Q&A
1

How can I optimize this expression?

I need to check first if any of those columns have negative values individually, and then sum them. If the sum value is zero, I prefer to leave blank, so I tried Decimal(““), but leaving blank isn’t working.

IF(
TOTALHOURS([Desviación entrada])< 0,
ABS(TOTALHOURS([Desviación entrada])),
DECIMAL(“”)
)

+

IF(
TOTALHOURS([Desviación salida])< 0,
ABS(TOTALHOURS([Desviación salida])),
DECIMAL(“”)
)

+

IF(
[Desviación receso] < 0,
ABS([Desviación receso]),
DECIMAL(“”)
)

Is there any software I could use to ident and space properly my expressions in appsheet?

2 
ANY(
  LIST(
    IFS(
      TOTALHOURS([Desviación entrada]) < 0,
        ABS(TOTALHOURS([Desviación entrada]))
    )
    + IFS(
      TOTALHOURS([Desviación salida]) < 0,
        ABS(TOTALHOURS([Desviación salida]))
    )
    + IFS(
      [Desviación receso] < 0,
        ABS([Desviación receso])
    )
  )
  - LIST(0.0)
)

image
image1528×420 27.7 KB

3

Thank you so much Steve!