Ledger with two ref rows amount to credit and debit transection

[valayvora]

Current Setup & output of results in 3 images Below:

Result I require in reference list as shown in image below:

[MultiTech]

Since you’ve already got things split out into separate Ref_Rows(), you could simply hide those and use list addition to combine them together into one; then hide the original two and only show the combination.

help.appsheet.com

List Addition

Add lists together to produce another containing all items in the originals.

[valayvora]

Thanks it solved one of my issue of combining two ref rows.
But is it possible to make this kind of relation with ledger as shown in edited image?
or i have to approach with different kind of idea or set of tables to achieve my required result?

[MultiTech]

It looks like you’ve got your credit and debit entries separated out into table; if you combined them together into one, with a [Transaction_Type] column, then you wouldn’t have to have things split up like this.

---

But if you’re wanting to keep things has you have them, what you need to do is create a “Display” virtual column - to serve as the label.

IF(isnotblank([Credit_Ref]), 
  [Credit_Ref].[Name],
[Debit_Ref].[Name)

This way, no matter what type of transaction something is, there is a unified field you can show that functions as the label.
(Oh, and mark this virtual column as the label for that row too. )