Between Not Working (challenge one)

[kumarnatarajan]

Hi all,

I am useing below mentioned syntex for get count between value. But it is not working. Any one help me

=Count({$<[Scenario Pl]={">= $(=Column(1))"}>*<[Scenario Pl]={"<= $(=Below(Column(1)))"}>}[Scenario Pl])

Or

=Count({$<[Scenario Pl]={">= $(=Column(1)) <= $(=Below(Column(1)))"}>}[Scenario Pl])

find the attached file

[Gysbert_Wassenaar]

You can't use the below function or column references in set analysis expressions. The set is calculated for the entire chart when rows and columns don't exist yet. You'll have to use if statements instead.

[kumarnatarajan]

Hi Gysbert Wassenaar ,

Ok but i want check mutiple value so how it is possible in if statement.

I used below mentioned syntex but it is not working

count(if(Column(1) >= [Scenario Pl] and Below(Column(1)) <= [Scenario Pl],1,0))

[er_mohit]

You have to try on this

i have attached a example

b:

LOAD * INLINE [

    A, D

    6, q

    7, h

    8, a

    9, c

];

Indirect Set Analysis

sum({$<CompanyName = p({$<CategoryName={'Baby Clothes'}>}

CompanyName)>} Sales)

Sales for Customers who purchased Baby Clothes.

The set p({}) returns the values of CompanyName (Customer) that

purchased Baby Clothes.

sum({$<CompanyName = p({$<CategoryName={'Baby Clothes'}>}

CompanyName) - p({$<CategoryName={'SportsWear'}>}

CompanyName)>} Sales)

Sales for Customers who purchased Baby Clothes but not

Sportswear.The first set p({}) returns CompanyName that purchased

Baby Clothes.The second set p({}) returns CompanyName that

Purchased SportsWear.The Unary Operator "-" between the two gives

a list of Customers (CompanyName)that belong to the first but not the

other set.

hope it helps

[kumarnatarajan]

Hi,

It is not working. please find the my attached file.

[kumarnatarajan]

Please find my attached file and give me good solution. it is very help full for me.

[er_mohit]

i doesn't open your file because m working on personal edition

see my example

[kumarnatarajan]

Hi,

I used this below mentioned condition in my exp.,But it's return string value. So how can i dothis in simple eay any one help me.

find the attached file

[kumarnatarajan]

This is Creating condition string.

=0&Replace(Concat( 'if(Column(1)>='& [Scenario Pl] &' And Below(Column(1))<= ' & [Scenario Pl] &',1)','+'),

SubField(Concat( 'if(Column(1)>='& [Scenario Pl] &' And Below(Column(1))<= ' & [Scenario Pl] &',1)','+'),'+',1),'')