Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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