Logic

[#1]

Fist of all thanks for the continuing help that everyone is giving.

im trying to write a expression logic,

what i want to put is sum all time where taskname = x and y and z

so far have tried sum (time) and TakName ='Amends', but i dont get nothing.

then i want to show this as top ten.

can you help please

Regads

T

[jvitantonio]

Hi,

Try this:

Sum(<1{[TasName]={"x","y","z"} >} Time)

You can look for "Set Analysis" in help for more details.

JV

BI Experience | A place to share our Business Intelligence experiences

[mjm]

Hello Tyrone,

to achieve this, you would need to use Set Analysis within the Sum(time) calculation.

I believe this would work for you SUM({1<TakName={'Amends'}>}Time)

This means take a complete set within the sum of time, where TakName=Amends. 1 means the whole data set in this expression.

The sorting can then be achieved in a chart for example, using Y Value descending

Hope this helps. Please mark as answered if this does help.

Thanks

[#4]

how do i write that out?

[mjm]

I am not sure what you mean by this sorry, but this SUM statement would be used as the expression itself. I understand you want to use this for example in charts, so this would be the expression used for the chart itself.

[jvitantonio]

You need to put this in an expression in a chart. Or a text box... Do you have any knowledge of QV? If you want you can attach your app so we can work on it.

JV

BI Experience | A place to share our Business Intelligence experiences