Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar

May be this:

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

Anonymous
Not applicable
Author

Thanks this worked.