Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to write a formula that will give me the following detail for each of the two columns Svc Group and Svc line.
I only want to pull in the following from Svc Group:
MC
RC
TR
And I only want to pull in the following from Svc Line:
Transaction
FRM
RC Other
Technology Enablement
Can anyone please help
May be try this expression:
Count({<[Svc Group] = {'MC', 'RC', 'TR'}, [Svc Line] = {'Transaction', 'FRM', 'RC Other', 'Technology Enablement'}>}[Partner ID])
May be try this expression:
Count({<[Svc Group] = {'MC', 'RC', 'TR'}, [Svc Line] = {'Transaction', 'FRM', 'RC Other', 'Technology Enablement'}>}[Partner ID])
Or this, if this is not and condition, but an or condition (show this or show that)
Count({<[Svc Group] = {'MC', 'RC', 'TR'}>+<[Svc Line] = {'Transaction', 'FRM', 'RC Other', 'Technology Enablement'}>}[Partner ID])
load *,
........
from table
Where svcgroup='mc','rc','tr' and Svcline='
'Transaction',
'FRM',
'RC Other',
'Technology Enablement';
If I were to go this route I would do this in the edit script correct?
Would this limit svc group and svc line to only those that I've selected throughout the file. So any graphs or charts that I use it will only display svcgroup='mc','rc','tr' and Svcline='
'Transaction',
'FRM',
'RC Other',
'Technology Enablement';
sunindia I notice that after Count you have {< and at the end of your formula you have >}. Why do you have these in there?
This is a set analysis syntax. For more information on set analysis, it would be good to spend some time on the attached document