Schema/Table Views/Totals

1

Hi Team,

I’m trying to be economical with my schema design. I have lots of formula columns that repeat, so I’m linking to One Big Table and using views of that table. However in each view it will have a total column and in each view often the formulas can vary to create a total.

Since I can’t name a column the same is there a smart work around outside of using Total 1, Total 2, Total 3…In terms of the naming.

All the best,

Ivan

2

Figured it out
thisRow.[DB Zero Qty X Amt Total].Filter(thisRow.[DB Formula Type]=“QtyxAmt”)+thisRow.[DB Zero Qty x AmT x Mul Total].Filter(thisRow.[DB Formula Type]=“QtyxMulxAmt”)