Hi All,
I’m building a Universe based on spreadsheet data. I have some complex formula in Excel that i have to do in the Universe level. Can someone please help me with the below formulas in spreasheet to be converted into the Designer functions.
MIN(ABS(V6),ABS(I6+N6)) - v6 is column v,6th row, i6-i col, 6th row & so on
MIN(ABS(M6),ABS(SUM(G6,J6,L6,AG6)-SUM(AC6,AB6,AA6)))
Also some of the columns are derived columns, from other ones, so i need to use that objects instead of the db column directly .
thanks,
ashwin (BOB member since 2010-04-26)