I can see the cause for confusion, @anilparikh1.
The forum-documentation says: “If your spreadsheet does not include any unreconciled manual transactions, the Tiller balance is not shown.” … but perhaps this is too buried.
I wrote the dashboard to hide the Tiller balance if there wasn’t a difference because I thought the Tiller balance would be confusing to (the majority of?) users who don’t use manual balances.
There is a formula in E20 that looks like this: =if(countif($AV$3:$AV,"<>0"),ARRAYFORMULA(IFERROR(VLOOKUP(row($AO3:$AO103)-Row($AO$3), {$AP$3:$AP, $AW$3:$AW}, 2, FALSE), iferror(1/0))),iferror(1/0))
If you want to make the Tiller column always present, just remove the initial IF
statement. (Though I think there may be a bug— identified in another thread—in this formula that I need to fix this week… so you may have to make this change again soon.)
Good luck,
Randy