Below condition is used to get unbilled amount in unallocated payment report in sql query. Without using that condition the unbilled amount is not matching. How to use that condition in qliksense? Any changes needed?
=if([Account no]=previous([Account no]);0; sum(To number([check no] In ([ Account no]))))+0
