Set Analysis Expression

[tmumaw]

Good morning everyone.  Sort of confused on this one.  The "if" statement works, but the set analysis does not.  Does anyone see anything that would make it not work?  Would love to use set analysis

Thanks

sum(if([Profit Center] = [Hist Profit Center] and YTDFlag = '1',LID))   (WORKS)

 
sum({<[Profit Center] = {“$(=trim([Hist Profit Center]))”},FISPD=,YTDFlag = {'1'}>} [LID]) (DON'T WORK)

sum({<[Profit Center] = {[Hist Profit Center]},FISPD=,YTDFlag = {1}>} [LID])  (DON'T WORK)

[CELAMBARASAN]

Hi,

I hope that you have unique key for the table

sum({<[UniqueKeyField] = {“=[Hist Profit Center] = [Profit Center]”},FISPD=,YTDFlag = {'1'}>} [LID])

Hope it helps

Celambarasan