Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I need get a value of the object calculed already, and sum with other value calculed too. With GetObjectField(0,'CH110') a can get the dimension os object, but if i want get a column, for example:
GetObjectField(0,'CH110') ===== 'Furto'
But I need the 300.065, how i can get?
Thanks.
You reference an already calculated column within the same object using function
Column(n)
Where n is the number of the expression column -- 1 being the first expression and so on.
You may not reference the column value from another object.
-Rob
If(GetObjectField(0,'CH110') = COLUMN1, SUM(COLUMN2))
I guess this could help you
Not works.
GetObjectField(0,'CH110') return a string...I need a index of columns.
Can you share some sample data and what you are expected output should be?
Attached.
Thanks.
You reference an already calculated column within the same object using function
Column(n)
Where n is the number of the expression column -- 1 being the first expression and so on.
You may not reference the column value from another object.
-Rob
I am not sure if i understand you correctly. May be you can use this expr to get 78. Like
= Sum(Aggr(Sum(VALOR), DCTO))
Is it not what you looking for?