Negative

[gr_sp]

Hello everyone,

In my report (Report 6i), it has a Number field, referring to the sum of a column. (SUM)

I would like this field to be negative (-).

What should I do?

Thanks.

[Diego_Mello]

Multiplies by -1.

[gr_sp]

This is the function of the field:

Select all

 function "nome_procedure" return boolean is 
begin 
   
  return (TRUE); 
end;  

Where should I insert the -1?

Thanks.

[Diego_Mello]

So ..
if you can, multiplication on your query.
Since, it creates a formula that does.

[rodfbar]

Good afternoon. 99]]

Select all

 
if :campo_soma >= 0 then 
  return false;  
else  
  return true; 
end if;

Abrçs

[gr_sp]

Give me an example, please.

I do not know where to put on Query.

[Diego_Mello]

Select all

 
SELECT sua_soma * -1 
   FROM tabela; 

[gr_sp]

But there is one thing, this sum field is not in the report query.

is a Summary Column ... which is created when doing a report.

Do you understand?

Thanks for the help.

[Diego_Mello]

Beauty ..
Then creates a column formula that will return it multiplied by -1.

[gr_sp]

I can not create, is not it just to go in Formula Columns and click Create?