Amount in negative

Kashmala Zaman

Hello,

How can I show the amount in negative when the status changes.

For example, here in the screenshot, the red highlighted one has the status 'OUT'. I want the amount to show in negative in the next column. Thanks

Paul Newcome

Try this:

=IF(Status@row = "OUT", 0 - [Amount in LC]@row)

Genevieve P.

Hi @Kashmala Zaman

Instead of looking for the exact status of "OUT", you can look to see if the cell contains the word "out" with other text by using the CONTAINS Function.

Try:

=IF(CONTAINS("OUT", Status@row), 0 - [Amount in LC]@row)

Cheers,

Genevieve

Paul Newcome

Try this:

=IF(Status@row = "OUT", 0 - [Amount in LC]@row)

Kashmala Zaman

@Paul Newcome  Thank You :)

Paul Newcome

Happy to help. 👍️

Kashmala Zaman

Hi, @Paul Newcome I have a follow-up question. How to build the same formula for different statuses.

This is the list of statuses we have.

OUT - to the next month

OUT - to the future month

IN - Into the current month

The value should be shown with a negative sign for status Out and a positive sign for status IN

Genevieve P.

Hi @Kashmala Zaman

Instead of looking for the exact status of "OUT", you can look to see if the cell contains the word "out" with other text by using the CONTAINS Function.

Try:

=IF(CONTAINS("OUT", Status@row), 0 - [Amount in LC]@row)

Cheers,

Genevieve

Kashmala Zaman

Thank you @Genevieve P. :)