4 Replies Latest reply: May 7, 2013 6:34 AM by Vishwaranjan Kumar

# Logical expression inside main expression

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

• ###### Re: Logical expression inside main expression

actually this looks quite Ok :

=sum({<Period1={'>=\$(=min(Period0)) <=\$(=max(Period0))'}>} Counter)

Try changing single with double quotes or else please post a sample application.

• ###### Re: Logical expression inside main expression

coun({1<Period1=P(Period0)>}Counter)

• ###### Re: Logical expression inside main expression

=sum({1<Period1= P(Period0)>} Counter)

• ###### Re: Logical expression inside main expression

sum({<OrderDate = {\$(DeliveryDate)}>} Sales)