How to organize comma list into bullet list

[chiukim]

Please see attached photo.

I want to organize the columns labeled ‘YES’ and ‘NO’ into bullet points for easier readability. Are there alternative ways to present it this way in a report?

Expected result:

(For column “YES”)

-Suspense and other temporary accounts are zero at month end - Asset Suspense
-Suspense and other temporary accounts are zero at month end - Inventory Suspense
-Suspense and other temporary accounts are zero at month end - Invoice Suspense
-Goods received not invoice (Note: No Pending GRNI for more than 2 days). - Inventory Suspense+ Input Tax Suspense+ Cost of Sales Suspense = GRNI (ref. Balance Sheet)

• A/P Others must be zero at the month end - Inventory Integrity Summary
• Cash Underage must be closed as of monthend-VVR.

The same application column “NO”.

[TeeSee1]

Here is something you can try.

Create a VC with

"- " & SUBSTITUTE([your column], "'", "
- ")

// Corrected expression
"- " & SUBSTITUTE([your column], ",", "  //second argument of SUBSTITUTE
- ")

and use this VC in your template. Adjust spaces to fit your text. The important thing is to actually break the line in the expression

[chiukim]

Thank you but theres an error occurred.

[TeeSee1]

A typo in my response expression.

The second argument of the SUBSTITUTE should be a comma ( , ) not an apostrophe ( ’ ).

[chiukim]

Thank you. the expression now is valid. But the outcome is not the same we expected even though i adjusted the spaces.

[TeeSee1]

If you paste raw text here, I can try to see if I get a different result.

[chiukim]

Here is the list :

Suspense and other temporary accounts are zero at month end - ASSET Suspense , Suspense and other temporary accounts are zero at month end - INVENTORY Suspense , Suspense and other temporary accounts are zero at month end - INVOICE Suspense , Goods Received Not Invoice (Note: No Pending GRNI for more than 2 days). , Inventory Suspense + Input Tax Suspense + Cost of Sales Suspense = GRNI (ref. Balance Sheet) , A/P Others must be zero at the month end , Inventory Integrity Summary , Cash Underage must be closed as of monthend

But in app’s view the virtual column is working

[TeeSee1]

It works for me. I have not changed the template one bit…

I cannot think of any other thing to try…

[chiukim]

It worked now. i just follow your screeenshot actual formula and removed spaces and change type to longtext instead of text. Thanks alot.