HI All
Looking for a bit of guidance on this one.
I am trying to create a project total view that will show the overall project costs for new quotes.
For Ref I have tables called:
Equipment 1 - 6 - These all have separate total views for each table
using formula
sum(
Select(
Quote Sheet Equipment 1 [Total Equipment Cost],[Quote Key]=[_THISROW].[Quote Key]))
In each column
However, I need a statement that closer resembles
sum(
Select(
Quote Sheet Equipment 1 [Total Equipment Cost],[Quote Key]=[_THISROW].[Quote Key]))
and(
Quote Sheet Equipment 2 [Total Equipment Cost],[Quote Key]=[_THISROW].[Quote Key])))
I now the above expression isn’t correct but I’m sure you’ll get the gist of it.
I have tried adding a and statement but I can only get it to work if it an and on the [Quote Key]=[_THISROW].[Quote Key] Part.
Any help is appreciated.
Thanks
Blake