Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need the below condition in set analysis..
(Sum({$} TOTAL SameStoreSalesTY)- Sum({$} TOTAL [Last Year MTD]))
where [Sold Location]={'17','18','29','70','76','102','105','129'}
Thanks..
Perhaps This
(Sum({$< [Sold Location] = {'17','18','29','70','76','102','105','129'}>} TOTAL SameStoreSalesTY) -
Sum({$< [Sold Location] = {'17','18','29','70','76','102','105','129'}>} TOTAL [Last Year MTD]))
OR
(Sum({<Flag = {'$'}, [Sold Location] = {'17','18','29','70','76','102','105','129'}>} TOTAL SameStoreSalesTY) -
Sum({<Flag = {'$'}, [Sold Location] = {'17','18','29','70','76','102','105','129'}>} TOTAL [Last Year MTD]))
Hi,
Try this:
(Sum(TOTAL {$<[Sold Location]={'17','18','29','70','76','102','105','129'}>} SameStoreSalesTY)-
Sum(TOTAL {$<[Sold Location]={'17','18','29','70','76','102','105','129'}>} [Last Year MTD])
)
HTH
May be like this ?
Sum ( {$<[Sold Location]={'17','18','29','70','76','102','105','129'}>}TOTAL SameStoreSalesTY)
-
Sum ( {$<[Sold Location]={'17','18','29','70','76','102','105','129'}>}TOTAL [Last Year MTD] )
I hope this may helps you.
-Nagarjun
its showing some error
What was the error? And In your Condition does $ is acting over there? I've removed Starting and Ending Parenthesis from my earlier set operator
Sum({$< [Sold Location] = {'17','18','29','70','76','102','105','129'}>} TOTAL SameStoreSalesTY) -
Sum({$< [Sold Location] = {'17','18','29','70','76','102','105','129'}>} TOTAL [Last Year MTD])
i need which requirement going to use this set analysis, please suggest.
i have been used one requirement but it not apt.