Ignoring Duplicate members

[former_member758749]

Hello guys!

I have a BW Query in wich I want to sum all the record from a column, but I don't want to sum the members that appear more than once. I haven't had luck to found some kind of formula that can to skip the record if it is there more than once.

I really apreciate your help.

[former_member759577]

Hi

I think you need to do it in the back end data model, not possible at query level.