FormerMember

Is there a way to return distinct results in MyAssistant?

Posted By FormerMember

I'm trying to run a task that pulls prior year actuals from the GL for all accounts not equal to zero at year end, but the task returns almost 400,000 results with dozens of duplicates for each account type.  Is there a way to return only distinct values?

Condition currently: "GLM_MASTER__ACCOUNT"."End_Balance_1_Year_Ago" <>0

Notification columns are: Account, Account Title, and each period for the prior year.