Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this:
=Count({$<[F-dimension]={'Yes'}, C-Days = {'>=90'}>} [C-value])
count({$<[F-dimension]={'Yes'}, c-days = {if(c-days >= '90', c-days)}>} [C-value])
Note, typo errors are there try fyi resolve that
May be this:
=Count({$<[F-dimension]={'Yes'}, C-Days = {'>=90'}>} [C-value])
Thanks this worked.