One dimention to select certain variable in expression

[mohiahmed]

Hello Team,

I am trying to bring in one dimention (Related Collateral =Y) to my query.  However, every time i am trying it getting null value.

How can I incorpotate (Related Collateral =Y) to my expression, please help.

Many Thanks in advance.

Regards

Mohi

[vinieme12]

Using SetAnalysis

count({<Related Collateral ={'Y'} >}  [YourFieldName] )

Set Analysis: syntaxes, examples

[mohiahmed]

Thanks Pujari, however when I add that to second part of my expression it coming up with an error

Please help

count

({<[Related Collateral] ={'Y'} >}[New Unsecured DD SLA])/count({<[Related Collateral] ={'Y'}>}(total<[Processing Area]>[New Unsecured DD SLA]))

[vinieme12]

Learning Set Analysis from Scratch

A Primer on Set Analysis

[adamdavi3s]

Looks like it might just be an extra bracket set in there to me

count({<[Related Collateral] ={'Y'} >}[New Unsecured DD SLA])

/

count({<[Related Collateral] ={'Y'}>}total<[Processing Area]>[New Unsecured DD SLA])

[vinieme12]

count({<[Related Collateral] ={'Y'} >}[New Unsecured DD SLA])

/

count(TOTAL <[Processing Area]> {<[Related Collateral] ={'Y'}>} [New Unsecured DD SLA])

[marcus_sommer]

Try this:

count({<[Related Collateral] ={'Y'} >} [New Unsecured DD SLA]) /

count({<[Related Collateral] ={'Y'}>} total<[Processing Area]> [New Unsecured DD SLA])

- Marcus

[Anil_Babu_Samineni]

Remove parenthesis of before Total and then remove one more of end part.

[adamdavi3s]

well done for copying at least two of the above answers