How to get selected value from perticular

[ravindraa]

I struck in place please give me any suggesion.
  My requierment is i have to caliculate officere time present.

to get the caliculation field i need to follow one caliculation.

Requierment:

timespent with studentactivity + timespent with parents_activity or timespent with other_activity + timespent with sports_activity.

in the edit script level i wrote like this.

fileter_time:
load
*,

****///If(Match(Officer_present , 'Parents_activity', 'sports_activity', 'Student_activity'), time_spent) AS Filter_time_spent,

from datasource;

please find the attchmets.

i am struck where i have to write or condition.

Please give any suggesion.
Thanks to advance.

[ravindraa]

Hi experts,

Please give me any suggesion on this.

thanks

Ravindra

[#3]

Hi ravindraa,

I think you do not need to write any extra code in EDIT SCRIPT Window. Just IMPORT the Excel.

Now you can smply write the follwing code in any expression.

= if(SubStringCount('|' & Concat(distinct Officer_present, '|') & '|', '|Parents_activity|'),
(Sum(if(Officer_present='Student_activity',time_spent)) +
Sum(if(Officer_present='sports_activity' ,time_spent)) +
Sum(if(Officer_present='Parents_activity' ,time_spent))),
(Sum(if(Officer_present='Student_activity',time_spent)) +
Sum(if(Officer_present='sports_activity' ,time_spent)) +
Sum(if(Officer_present='other_activity' ,time_spent))))

Pls refer to the qvw attached.

[ravindraa]

Hi Kuntal Dey,

  Thaks for reply but i have to use caliculation field for other place as input field thats why , please give me any suggession.

Thanks

Ravindra

[#5]

Did not get you. Can u pls specify more clearly

[ravindraa]

Hi Kuntal Dey,

  I have to caliculate the officer time spent for one field.

Because after create this i have to calicute the % wise time spent (%time=(Filter_time_spent/Time spent fullhours)*100).

thats why please give me suggesion on this.

thanks in advance.

[ravindraa]

Hi experts please help me onthis issue.