| summarize function decode [message #407277] |
Tue, 09 June 2009 07:15  |
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?
Greetz,
JR
|
|
|
|
| Re: summarize function decode [message #407699 is a reply to message #407277] |
Thu, 11 June 2009 02:48  |
nagu_bhat
Messages: 10
Registered: May 2009
|
Junior Member |
|
|
hi
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.
Regards
Nagaraj
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
