Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Using SetAnalysis
count({<Related Collateral ={'Y'} >} [YourFieldName] )
Set Analysis: syntaxes, examples
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]))
Learning Set Analysis from Scratch
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])
count({<[Related Collateral] ={'Y'} >}[New Unsecured DD SLA])
/
count(TOTAL <[Processing Area]> {<[Related Collateral] ={'Y'}>} [New Unsecured DD SLA])
Try this:
count({<[Related Collateral] ={'Y'} >} [New Unsecured DD SLA]) /
count({<[Related Collateral] ={'Y'}>} total<[Processing Area]> [New Unsecured DD SLA])
- Marcus
Remove parenthesis of before Total and then remove one more of end part.
well done for copying at least two of the above answers