Home » Developer & Programmer » Forms » summarize function decode
summarize function decode [message #407277] Tue, 09 June 2009 07:15 Go to next message
vallis a rosa
Messages: 4
Registered: April 2009
Junior Member
Hello everyone,

I have a couple of field that i want to summarize. I can do it with the calculation mode, but i have to use a decode. In the fields there are record that values -1, but i have to decode them to 0. So i need to have " decode(:wvgepl1, -1 , 0 , :wvgepl1) into a formula, but i dont know how to do it. Without the decode it works fine.

Is there a way to do it?


Re: summarize function decode [message #407699 is a reply to message #407277] Thu, 11 June 2009 02:48 Go to previous message
Messages: 10
Registered: May 2009
Junior Member

put a dummy field in the block and make the database item as 'YES' and in the column name put the decode functionality u require. and u can use this field for summarising.

Previous Topic: calling report from oracel form
Next Topic: grant execution to a program unit in Forms
Goto Forum:

Current Time: Fri Oct 21 04:15:45 CDT 2016

Total time taken to generate the page: 0.13857 seconds