3 Replies Latest reply on Sep 14, 2016 2:00 PM by ed.d.1

# How to add multiple rows for calculated field

Hello Guys,

I'm trying to figure out if possible to add multiple rows for calculated field. Any suggestion would be really appreciated and thanks!

 Period  start time (copy) Class Type Name Score Required Calculated Field 7/18/2016 1 B RYANF2 166.4791667 [Add all Class "1" Score] * (15/35) 7/18/2016 3 L RYANF 46.6875 [Add all Class "3" Score] * (20/35] 7/18/2016 1 L RYANF 46.46875 [Add all Class "1" Score] * (20/35) 7/18/2016 3 B RYANF2 56.375 [Add all Class "3" Score] * (15/35]
• ###### 1. Re: How to add multiple rows for calculated field

As per my understanding is that what you're looking for? Required calculation is your class wise Final score. Let me know If you've any query.

Workbook has been attached for your reference.

Mahfooj

• ###### 2. Re: How to add multiple rows for calculated field

Thank Mahfooj! The idea is there however I should have also mention clearly before the following:

1. There will be a different multiplier for type "B" and type "L" - (15/35) and (20/35) respectively.

2. Date or Date/Time will be a factor too since I'll be doing this for a very large data set of different time.

• ###### 3. Re: How to add multiple rows for calculated field

I guess I got it now but have to try it on my actual data set.

As Mahfooj Khan example he used FIXED and it seems working.

The way it works is tricky since the logic differs the way you arrange your measures here. I'll update this post if works for a big set of data. Thanks again,

{FIXED [Date], [Type]  :SUM([Score])}