Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results 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
MVP

May be this:

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

3 Replies

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)
MVP

May be this:

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

Anonymous
Not applicable
Author

Thanks this worked.

Community Browser