Arithmetic expression has input of type unknown

[da_common]

Hi,

I am facing the above issue when i try to use the following formula

if([_thisrow].[_RowNumber]=1,[_thisrow].[Amount],lookup([_thisrow].[_Rownumber]-1,"Ledger data sender","_RowNumber","Balance")+[_Thisrow].[Debit]-[_Thisrow].[Credit])

ERROR

Arithmetic expression '(ANY(SELECT(Ledger data sender[Balance],([_RowNumber] = ([_thisrow].[_RowNumber]-1))))+[_Thisrow].[Debit])' has inputs of an invalid type 'Unknown'

The above columns are from a table calculating balance of the customer based on debit, credit and value to balance in the previous row.

Any insight into what might be causing this? this occurs if i add + or - columns in the formula