Add a numeric flow field in negative sign

Hi all,

I am going to add a numeric flow field in negative sign to a table and display on a page. Since the negative sign can only supported by calformula “Sum” or “Average”, i can only using this two types. But the result is that when choosing “Sum” or “Average”, the output is zero. When change to use other types, e.g. “Max” or “Min”, it works but cannot apply the negaive sign function. What can i do?

Thanks in advance.

Noel

What CalcFormula you are using for FlowField?

And I hope you are using reverse Sign in CalcFormula.

A FlowField to do what? You can always add it to your Page with a SourceExpr = -Field to show the negative of the value, but I have a feeling your formula is incorrect.

Hi Matt,

There was an error after i added the negagive sign “-” before the field name.

e.g. -SalesCrMemoHeader.“Amount (LCY)”

Noel

test

Hi Mohana,

What CalcFormula you are using for FlowField

I choosed “MAX” for the FlowField, i.e. Max(“Cust. Ledger Entry”.“Sales (LCY)” WHERE (Document No.=FIELD(No.),Document Type=CONST(Credit Memo)))

If i used “SUM” and checked “Negaive Sign” for the FlowField, the output became zero. i.e. -Sum(“Cust. Ledger Entry”.“Sales (LCY)” WHERE (Document No.=FIELD(No.),Document Type=CONST(Credit Memo)))

Noel

And what is it that you are trying to calculate?

Hi Matt,

Negative Sales (LCY) amount of Cust. Ledger Entry.

Noel