Aggr Function replacement

[polisetti]

Hi

i had a issue with the data.In my db i had a split FSA ,in which for 10 FSA i have the same value .but i need to pick up only one value and it should be add to other normal FSA.I have a FLAG for Split FSA.

So i wrote

=Aggr(sum({<[Split FSA flag]={'Y'}>}[TSA Product Sales],[FSA Name]))

/

Sum{<[Split FSA Flag={'N'}]>}[TSA Product Sales]

It is working fine ,but instend of writing Aggr function can we write any other function.like-Only etc

[#2]

Can you have a look at comments of the thread below:

Aggr() function

Thanks,

Angad

[polisetti]

The expression which i wrote is correct,and it's working fine.But instend of AGGR () is there any other function or expression that should take only one value from 10 values in split FSA

[#4]

If the values are same, try using DISTINCT keyword.