#VALUE! result on some but not all rows

[Matt_BicycleBook]

Hello,

I am experiencing a #VALUE! error on 3 out of 7 calculated rows, and I can't identify the issue.

The column in question (ApproxValue) is multiplying NumberSites (from the same table) by CostPerSite (from another Rowlinked table). See image below:

Please let me know if you can help.

Thanks,
Matt

[Kamran]

Hi @Matt_BicycleBook,

ApproxValue should be using a slightly different syntax:

=[Product][CostPerSite] * [NumberSites]

This will use the value in the [Product] column of the current row to retrieve the CostPerSite of that specific product.

As entered right now, it is trying to guess which row should in Products table it should use since Products[CostPerSite] evaluates to the full column rather than a specific row. I believe it's failing after row 3 since most likely you have 3 rows in the products table. We'll see if we can improve this behavior to be more consistent.

Please let me know if you continue experiencing issue or have additional questions.

[AndrewB]

@Matt_BicycleBook

Is this what you're trying for?

=[NumberSites]*[Product][CostPerSite]

This will look at the rowink in your Product column, then the value of the CostPerSite column.

[Matt_BicycleBook]

Thank you @Kamran and @AndrewB, that has done the trick.

Helpful to understand where I was going wrong, makes sense now.

Thanks!
Matt