Showing results for 
Search instead for 
Did you mean: 

SUM([TEXT_FIELD]) stopped working after latest upgrade!

7 - Data Storage
7 - Data Storage

We're connecting to Sisense via Live-model on Snowflake DWH

when you use function sum("TEXT_FIELD") on snowflake it will create an auto-cast to numeric even though the type listed as varchar. if the varchar contain text value the sum will fail.

Until now when we tried to create a function of sum("TEXT_FIELD") in Sisense widget, it would work as the sql query behind will work.

after we upgraded to the latest patch the widget will prevent this use and will fail existing production widgets who uses this.

Our production has multiple of failed widgets because of it we need your help ASAP!

Waiting for your reply,