Page 1 of 1
calculated field
Posted: 2019-12-14 19:03
by dtessier
Hello,
I can't seem to get this to work. I have table tenants with field Rent I would like to do the following:
Rent * 12 / .4
I have attached a picture of the calculated field.
I hope I have included all of the required information and thanks in advance.
Re: calculated field
Posted: 2019-12-14 19:11
by jsetzer
Code: Select all
select (Rent * 12 / 0.4) from tenants where yourPkColumnName = '%ID%'
Replace yourPkColumnName and check letter casing of table name and column names.
Best
Jan
Re: calculated field
Posted: 2019-12-14 19:21
by pbottcher
Hi,
why would you multiply with 12 and devide by .4? You could instead multiply by 30.
Also, there is not image attached to your post.
Re: calculated field
Posted: 2019-12-14 20:38
by dtessier
Thanks for the quick reply. I have attached the picture and still doesn't seem to work for me.
- appgini.jpg (192.09 KiB) Viewed 3147 times
Re: calculated field
Posted: 2019-12-14 20:45
by jsetzer
What exactly does not work? Just in case it shows 0 as result, you should change from integer to double or decimal data type.
Re: calculated field
Posted: 2019-12-15 13:22
by dtessier
appgini.jpg
it's not showing anything (gross income to qualify)
Re: calculated field
Posted: 2019-12-15 13:24
by dtessier
- appgini.jpg (73.26 KiB) Viewed 3120 times
Re: calculated field
Posted: 2019-12-15 13:50
by jsetzer
Are you sure both fields (Rent and the calculated field) are numeric?
Re: calculated field
Posted: 2019-12-15 15:29
by dtessier
Both fields are decimal