Expressions based on the values

[varunreddy]

Hi All,

I have two fields, CDE and DQ Metrics Process ID. Each CDE is associated to multiple Process ID's.

If the CDE is associated to Process ID that starts with 3 (i.e. 30000 or 30101), then I need one expression (i.e. sum(Process ID),

else Count(Process ID).

My dimension is CDE.

Can anyone please help me with the solution?

Thanks for your help in advance!

Cheers,

Varun

[hector_munoz]

Hi Varun,

If I have not understood you bad, you need to sum only when Process ID starts with "3"; else count Process ID... Would it serve this?

Sum(If(Left([Process ID], 1) = 3, [Process ID], 1))

Sure I am missing something in your explanations...

Regards,
H

[varunreddy]

Hi Hector,

Thanks for quick response.

CDE   Process ID

ABC     2000

DEF     3000

XYZ     3101

Here one CDE has two Process ID's.

I am trying to write expressions based on Process ID's.

If Process ID, starts with '3*' (i.e.3000 or 3101), then I want to write an expression sum(Process ID), else count(Process ID).

I also want to see sum(Process ID), when I select CDE (i.e. DEF or XYZ).

Please let me know, if you still have issues understanding this.

Thanks,

Varun

[vishsaggi]

Try this?

Dim:

CDE

Expr:

= IF([Process ID] >= 3000, Sum(TOTAL Aggr(Sum({< [Process ID] = {">=3000"} >}[Process ID]), [Process ID])), Count([Process ID]))

[el_aprendiz111]

Hi,