Custom Totals on Table

[anushree1]

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

[anushree1]

HI,

Any suggestions on this?

@Vegar 

[Vegar]

Do you really need your if statement as your two conditional statements are identical?

if(Dimensionality()=0,
Column(1)/Column(2)-1,
Column(1)/Column(2)-1
)

[anushree1 · Accepted solution]

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