Expression to find out Distinct value

[chaiwaykeat]

Hi All,

I am trying to pull the value from [Backlog_Actual (2).backlogamt] given that  to [Backlog_Actual (2).SO] is equal to [Sales Order] in the below expression:

sum ( if ([Backlog_Actual (2).SO]= [Sales Order],[Backlog_Actual (2).backlogamt]))

But by doing this I have duplicated value pulled from [Backlog_Actual (2).backlogamt] as my [Sales Order] contains duplicate values.

How can I avoid pulling the duplicated values ?

Thanks !

[tresB]

Try like:

sum (Distinct  if ([Backlog_Actual (2).SO]= [Sales Order],[Backlog_Actual (2).backlogamt]))

[chaiwaykeat]

by adding distinct the expression only pull out distinct value for [Backlog_Actual (2).backlogamt]

I will need distinct value for [Sales Order] when comparing it with [Backlog_Actual (2).SO]