Lobby Column using select query

I have found, to date, that i can only use select count(*) or sum - or use an api method to get a single value.It would be very powerful if IFS could find a way for calculated columns to have an alias and then be able to reference that for the same row - but in another column. In your example you are explicitly defining a field name in the select a.Price which i think is the issue. Can you get Price from api or maybe use sum - so you get the value if you supply the right key and only a single value exist then that might work..

Hi ​@Senthil 

usually, it works. I think your query is not correct.

where a.contract_id =  &AO.psc_contr_product_pric.contract_id

Try it in PLSQL developer.