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.
calculated field
Re: calculated field
Code: Select all
select (Rent * 12 / 0.4) from tenants where yourPkColumnName = '%ID%'
Best
Jan
Kind regards,
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
AppGini 24.10 Revision 1579 + all AppGini Helper tools
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
[code]...[/code]
blocks for better readabilityAppGini 24.10 Revision 1579 + all AppGini Helper tools
Re: calculated field
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.
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.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: calculated field
Thanks for the quick reply. I have attached the picture and still doesn't seem to work for me.
Re: calculated field
What exactly does not work? Just in case it shows 0 as result, you should change from integer to double or decimal data type.
Kind regards,
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
AppGini 24.10 Revision 1579 + all AppGini Helper tools
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
[code]...[/code]
blocks for better readabilityAppGini 24.10 Revision 1579 + all AppGini Helper tools
Re: calculated field
it's not showing anything (gross income to qualify)
Re: calculated field
Are you sure both fields (Rent and the calculated field) are numeric?
Kind regards,
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
AppGini 24.10 Revision 1579 + all AppGini Helper tools
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
[code]...[/code]
blocks for better readabilityAppGini 24.10 Revision 1579 + all AppGini Helper tools