Forum Discussion
Tevon713
Helper V
Helper Vsum value if less than 0
Hi.
Trying to sum a data field only if the sum of it is < 0 else do not sum it or return 0. IF statement or filter be best. I have over 3M records.
For example.
Acct #
Count
...
Sum count 1 = VAR _tbl = ADDCOLUMNS(VALUES(Data[Acct #]),"SUM", [Sum Count]) RETURN CALCULATE([Sum Count],_tbl) or Sum count 1 = VAR _tbl = ADDCOLUMNS(VALUES(Data[Acct #]),"SUM", [Sum Count]) RETURN sumx(_tbl,[SUM])
