Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

ADD two different sets of expressions

Hi,

I have two different sets in two charts:

a) =count({$<[F-dimension]={'Yes'}>}  [C-value])

b) =count(if(C-Days>='90' , [C-value])

Now I need to use both these conditions on a single chart.

I tried =count({$<[F-dimension]={'Yes'}>}  [C-value]) AND count(if(C-Days>='90' , [C-value]) but this does not give correct value.

Please can someone help.

1 Solution

Accepted Solutions
sunny_talwar

May be this:

=Count({$<[F-dimension]={'Yes'}, C-Days = {'>=90'}>}  [C-value])

View solution in original post

3 Replies
Anil_Babu_Samineni

count({$<[F-dimension]={'Yes'}, c-days = {if(c-days >= '90', c-days)}>}  [C-value])


Note, typo errors are there try fyi resolve that

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sunny_talwar

May be this:

=Count({$<[F-dimension]={'Yes'}, C-Days = {'>=90'}>}  [C-value])

Anonymous
Not applicable
Author

Thanks this worked.