issue on if condition

[#1]

Hi

Dimension : Type

i have expression like below:

if(BU=' ROLL',(Count({<Type={'App'},DEPT_L3={'Tech Solutions'},

DEPT={' Services',' Information Solutions','Workflow Solutions','Connected Care & Analytics',

'MHS','MTS Services'}, LC_STAGE={'Concept-Opportunity''},STATE={'Active'},WORK={'Application'}>}LC_STAGE)),

if(BU='ROLL',(Count({<Type={'Infrarad'},DEPT={'MTS '},

DEPT={'Services',' Information Solutions','Workflow Solutions','Connected Care & Analytics',

'MHS','MTS  Services'},

LC_STAGE={'Concept-Opportunity'},STATE={'Active'},

WORK={'DCT','Recovery'}>}LC_STAGE)),

when i am applying this expression tp the chart i am getting only one if condition values i.e  Type={'App'} but i am not getting Type={'Infrarad'} these vaules could u please help me out

Note : I need to show both Values i.e  Type={'Infrarad'},Type={'App'}

[sunny_talwar · Accepted solution]

How about this:

If(BU=' ROLL',

RangeSum(Count({<Type = {'App'}, DEPT_L3 = {'Tech Solutions'}, DEPT = {' Services', 'Information Solutions', 'Workflow Solutions', 'Connected Care & Analytics', 'MHS', 'MTS Services'}, LC_STAGE = {'Concept-Opportunity'}, STATE={'Active'}, WORK = {'Application'}>} LC_STAGE),

Count({<Type={'Infrarad'}, DEPT={'MTS '}, DEPT={'Services',' Information Solutions','Workflow Solutions','Connected Care & Analytics','MHS', 'MTS  Services'}, LC_STAGE={'Concept-Opportunity'}, STATE={'Active'}, WORK = {'DCT','Recovery'}>} LC_STAGE))

[#3]

Thanks sunny

[sunny_talwar]

No problem at all

[#5]

hi sunny

That scenario works out properly but here one more scenario which i am trying to do implement but i am not getting exact results could  you please help me on this

My Expression:

if(BU='MTS ROLLUP',

Rangesum(Count({<Type={'App'},DEPT={'MT Solutions)'}, DEPT={'Performance Services','Information Solutions','Imaging,' Analytics',

'Shared Services'}, LC_STAGE={'Test-Deploy'}, STATE={'Active'}, TIME={'Y'},TYPE={'Appl'}>} TIME)/

Count({<Type1b={'App'},DEPT={'MTS (McK Tech Solutions)'}, DEPT_L4={'Performance Services','Information Solutions','Imaging','Connected Care & Analytics','MD'},LC_STAGE={'Test-Deploy'},STATE={'Active'},TIME={'Y', 'N'}, WORK_TYPE={'Application'}>} TIME) * 100,

Rangesum(Count({<Type={'App'},DEPT={'MT Solutions)'}, DEPT={'Performance Services','Information Solutions','Imaging,' Analytics',

'Shared Services'}, LC_STAGE={'Test-Deploy'}, STATE={'Active'}, TIME={'Y'},TYPE={'Appl'}>} TIME)/

Count({<Type1b={'App'},DEPT={'MTS (McK Tech Solutions)'}, DEPT_L4={'Performance Services','Information Solutions','Imaging','Connected Care & Analytics','MD'},LC_STAGE={'Test-Deploy'},STATE={'Active'},TIME={'Y','N'},

WORK_TYPE={'DPT','Recovery & Infrastructure','Infrastructure','ISRM & Infrastructure','Merger & Acquisition}>} TIME) * 100,

Thanks

[sunny_talwar]

What are you getting and what do you want to get? Can you share a sample because just by looking at the expression, it might not be straight forward as to what might be missing

[#7]

If(BU=' ROLL',

RangeSum(Count({<Type = {'App'}, DEPT_L3 = {'Tech Solutions'}, DEPT = {' Services', 'Information Solutions', 'Workflow Solutions', 'Connected Care & Analytics', 'MHS', 'MTS Services'}, LC_STAGE = {'Concept-Opportunity'}, STATE={'Active'}, WORK = {'Application'}>} LC_STAGE),

Count({<Type={'Infrarad'}, DEPT={'MTS '}, DEPT={'Services',' Information Solutions','Workflow Solutions','Connected Care & Analytics','MHS', 'MTS  Services'}, LC_STAGE={'Concept-Opportunity'}, STATE={'Active'}, WORK = {'DCT','Recovery'}>} LC_STAGE))

By using this expression i got count but now i need to display the Percentage how to implement this scenario on the same expression

[sunny_talwar]

Percentage based on what? Based on a single dimension, multiple dimension? Yet again I feel we need more information before we can provide a working solution

[#9]

Calculated dimesion:  month &'-' &Type

Dimension values like AUG &'-'& APP like This

[#10]

Single dimension Only