#6477: Quire Feedback
Status: To-do

How to show multiple values in one formula field

Hello Quire Team,

I want to show several field values together in one formula column, including a small calculation.

Example:4 fields

PO No: 12345 PO Qty: 1200 Recv: 800 Bal: 400 (where Bal = PO Qty – Recv)

I want this in single field

Could you please guide me on: 1. How to combine text and numbers in one formula. 2. How to show a calculated value in the same formula. 3. How to make sure it works even if some fields are blank.

It would help if you can send a small sample formula using field names like {PO.NO}, {PO.ORD.QTY}, {RECIVED QTY}.

Thank you

Created by MD @NOBLE Aug 8, 2025, Edited Aug 8, 2025

Hi,

If you’d like to calculate the Bal  field by subtracting Recv  from PO Qty , you can use the following formula: {PO Qty} - Recv

To show text in formula results, you can wrap it in quotation marks " or ' . To display the results of all four fields together in one field, you can use this formula:

"PO.NO: " + {PO No} + " ; PO.ORD.QTY: " + {PO Qty} + " ; RECIVED QTY: " + Recv + " ; BALANCE: " + Bal

The result will appear like this:

If any of the fields are blank, the combined result will also be empty. Additionally, make sure to replace the field names with your actual field names for the formula to work correctly.

Please let me know if you have any questions.

Golda, Aug 8, 2025