set analysis(urgent)

[#1]

can i use 'getfieldselection' in the modifier?

[#2]

I think you can use any function in the modifier, so thisone as well. What are you trying to achieve, or what is the problem you run into?

[SunilChauhan]

see attached file

[#4]

i am trying this function:

sum

({$<[Time Bucket Name] = GetFieldSelections([Time Bucket Name]), [Time Bucket Type] = {'CURRENT'}, [TA Sort Order] =>}NUM_ACTV_PTNT) - sum({$<[Time Bucket Name] = GetFieldSelections([Time Bucket Name]), [Time Bucket Type] = {'PREVIOUS'}, [TA Sort Order] =>}NUM_ACTV_PTNT))

and as u can see, there is some error and the expression editor is also giving the error: Error in set modifier element function.

Please help

[#5]

I think it should be like this

sum

({

$<

[Time Bucket Name] = {$(=GetFieldSelections([Time Bucket Name]))},

[Time Bucket Type] = {'CURRENT'},

[TA Sort Order] =>}NUM_ACTV_PTNT

)

-

sum({$<[Time Bucket Name] = {$(=GetFieldSelections([Time Bucket Name]))},

[Time Bucket Type] = {'PREVIOUS'},

[TA Sort Order] =>}

NUM_ACTV_PTNT))

Please also compare your syntax with Sunil Chauhan's example. THe getFieldSelections() function cannot be used like you use it, but must be surrounded by {} and by $() (dollar sign expansion)

[SunilChauhan]

sum

({$<[Time Bucket Name] = {$(=GetFieldSelections([Time Bucket Name]))}, [Time Bucket Type] = {'CURRENT'}, [TA Sort Order] =>}NUM_ACTV_PTNT) - sum({$<[Time Bucket Name] = GetFieldSelections([Time Bucket Name]), [Time Bucket Type] = {'PREVIOUS'}, [TA Sort Order] =>}NUM_ACTV_PTNT))

use  this code

hope this helps

[#7]

I updated Sunil Chauhan's expression a bit, to support cases in which the field EMP has spaces in the field. See attached example.

[SunilChauhan]

its working i thing 

what is your problem now

[#9]

Thanks for the reply guys but it isn't working for me.

[#10]

Can you give some more details?

Ideally a sample QVW, but otherwise a description of what's going wrong?