SUM & SELECT by TODAY()

[RECMAN_Systems]

Hi there,

After hours of trying, reading, viewing Ytube tutorial I still can’t make it work. Therefore please help me out.

I have a Table Production where weight and date of production is added by the app.
[Weight] is a NUMBER
[Date of production] is a DATE

I am trying to build a KIP among others to sum up the today production in a virtual column

Present expressions are validated by AppSheet but still return 0 and can not figure out why…
++++++++++++++++++++++++++++
SUM(
SELECT(
MyTable[Weight],
DATE(MyTable[Date of production])=DATE(NOW())
)
)
++++++++++++++++++++++++++++

have tried also
++++++++++++++++++++++++++++
SUM(
SELECT(
MyTable[Weight],
DATE(MyTable[Date of production])=TODAY()
)
)
++++++++++++++++++++++++++++

It looks so straight forward but it not return the values I need.

Many htanks in advance for your help…
Lovro

[LeventK · Accepted solution]

@RECMAN_Systems

SUM(
    SELECT(
        MyTable[Weight],
        [Date of production] = TODAY()
    )
)

[RECMAN_Systems]

EUREKA

Thanks a lot