
1. Re: Calculating Multiple Rows of one Column Based on the Values in another column
meenu choudhary Jun 12, 2018 2:11 AM (in response to Albert Marsnik)1 of 1 people found this helpfulHi ,
You can try below logic:
Create three new measure :
1. labourCost = { FIXED [ID1]: max(if [Item1]='laborcost' then [Pricing] END)}
2. price ={ FIXED [ID1]: max(if [Item1]='price' then [Pricing] END)}
3. Quantity= { FIXED [ID1]: max(if [Item1]='quantity' then [Pricing] END)}
and then the final calculation for total price: [price]*[Quantity] +[labourCost]
Note: column name used in above logic are bit different from your's. You can change it and use it accordingly.

2. Re: Calculating Multiple Rows of one Column Based on the Values in another column
Sohan Jawar Jun 12, 2018 2:17 AM (in response to Albert Marsnik)Hi Albert,
Create a calculated field as below:
(IF ItemChangeDetails.PricingName = "Pricing" THEN ItemChangeDetails.PricingValue END) * (IF ItemChangeDetails.PricingName = "Quantity" THEN IntemChangeDetails.Pricing.Value) + (IF ItemChangeDetils.PricingName = "TotalLaborCost" THEN ItemChangeDetails.PricingValue)
Regards
Sohan.

3. Re: Calculating Multiple Rows of one Column Based on the Values in another column
Tushar More Jun 12, 2018 2:25 AM (in response to Albert Marsnik)Hi Albert,
Please find my approach in the attached workbook.
Let me know if this helps or not.
~Tushar

PriceCalculation.twbx 10.7 MB


4. Re: Calculating Multiple Rows of one Column Based on the Values in another column
Albert Marsnik Jun 12, 2018 3:39 AM (in response to Albert Marsnik)Thanks Meenu, that is just what I was looking for!

5. Re: Calculating Multiple Rows of one Column Based on the Values in another column
meenu choudhary Jun 12, 2018 8:14 AM (in response to Albert Marsnik)Happy to help