Select value as fails in summary

Scriptcase 9 General
#1

I have a simple table with a datetime, varchar and bigint. The bigint is a value in cents now I want to select it as a decimal Eg select value*0.01 as value
This works in a grid but fails in a summary. I have tried everything I can think of in desperation I create a temporary table with value as a decimal and select from the real table into the tmp table.

onRecord is not called for summaries so making a new field does not help, plus if you try to use a “created” field in a summary sc9 bombs out.

Anybody know how should one do this in sc9 ?

#2

Why not a Float instead of a bigint?

#3

I used this trivial example of converting cents to illustrate the shortcoming and bug in SC. The issue is it cannot handle “select as”