About da_common

da_common · 10-25-2023

Hi,I am facing the above issue when i try to use the following formulaif([_thisrow].[_RowNumber]=1,[_thisrow].[Amount],lookup([_thisrow].[_Rownumber]-1,"Ledger data sender","_RowNumber","Balance")+[_Thisrow].[Debit]-[_Thisrow].[Credit])ERRORArithmeti...

da_common · 10-22-2023

If the cell of the column referenced by the lookup is empty, the lookup returns the first value of the data set.Any solutions to this issue?tried to force a nill value using if/else but its not working

da_common · 10-21-2023

Same, its just updating the same row in place one by one till only the last value is updated. The count is updating as well.Any tips? Thanks in Advance

My Stats

Chenyu's Bio

Badges da_common Earned

Recent Activity

Arithmetic expression has input of type unknown

Re: Initial Values: SELECT, ANY, or LOOKUP?

Re: FAQ: add row per value in EnumList