Hi. I'm trying to build some expression which should be calculated by logical terms.
my way1:
=sum({<Period1={'>=$(=min(Period0)) <=$(=max(Period0))'}>} Counter)
my way2:
=sum({$<Period1= {'$(=Period0)=(=Period1)'}>} Counter)
i'm trying to do something like this:
sum({$<OrderDate = DeliveryDate>} Sales) - from help of set analysis
but it's not working...
Period1 and Period0 it's dimensions.
When i using in chart my first Period1 dimension all working okay. But when i trying to use the second - damn.
=sum({<Period1={'>=$(=min(Period0)) <=$(=max(Period0))'}>} Counter)
my logic is:
IF Period1=Period0 THEN I TAKES RECEIVED DATE INTO Period1 AND THEN COUNTING FOR THAT DATE.
Help if it's possible )) thnx
