Wrong result in count statement,

HBT
Silver 4
Silver 4

In Bot-Events-Process- branch on a condition- Expression Assistant- Condition

Although there are records in the table, the query below returned the value of the number of records a week ago, but now returns 0.

COUNT(SELECT(table[XID],[XID]=[_THISROW].[ID]))=0 ( Yes or No )

For example, the return result should be 1=0, but it is 0=0.

I solved my problem using other logic, but this problem needs to be investigated and solved.

I think it's a new bug. Please research and analyze this topic.

0 1 67
1 REPLY 1

Are you seeing this in the new Desktop Mode Preview when adding a NEW row? 

If so, this has been reported as an issue in that thread.  The diff being that in the new Desktop mode a new row is "added" and considered part of the dataset BEFORE tapping the Save button.  In the legacy Desktop and Mobile devices, the new row is considered part of the dataset only AFTER tapping Save.

Top Labels in this Space