Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to create expression total on a Table object , and happened to use the below expression to obtain the same
if(Dimensionality()=0,Column(1)/Column(2)-1, Column(1)/Column(2)-1)
But this results in - as totals .
Can someone help me on the same
Please Note: Column(1) and Column(2) are derived using Valuelist Expressions
HI Vegar,
Thanks for the reply.
As I wanted to to YOY Calculation on the column and considering that column 1 and column 2 were derived using Value list expressions , the available options on total were limited to sum,avg,count,min and max but i wanted the expression calculation hence was trying for it using the if construct.
Now I changed the first part of if to have valuelist calculations with a small tweak and it started working.
Thanks for your time
HI Vegar,
Thanks for the reply.
As I wanted to to YOY Calculation on the column and considering that column 1 and column 2 were derived using Value list expressions , the available options on total were limited to sum,avg,count,min and max but i wanted the expression calculation hence was trying for it using the if construct.
Now I changed the first part of if to have valuelist calculations with a small tweak and it started working.
Thanks for your time