Skip to Content
0
Mar 17, 2009 at 08:24 PM

Pecentage field error - Univer Builder

27 Views

Hi,

I am tryng to add a feild with 1 decimal place to my univers and I receive the following error

"Parse failled: Excepttion Microsoft [ODBC SQL Server Driver] statements could not be prepared State: 42000

The field is a calculation of two other fields inthe same table (field 1 / field 2) so I tired to create the field directly in Universe designer as well with a formula, but it will not index in Polestar.I did put logic in to avoid divid byzero and the data looks clean in MS SQL

I will give points.

Thanks,

Mike