2 Replies Latest reply on Oct 1, 2018 8:21 PM by Monisha Ramesh

# I would like arrows for my all my measure values

Please ignore the look of those letters A.B.C.D.E for each column.

I placed this formula:

if ZN(COUNT([worksheet id])) - LOOKUP(ZN(COUNT([worksheet id=1])), -1) > 0

then 'increase'

else if ZN(COUNT([worksheet id=1])) - LOOKUP(ZN(COUNT([worksheet id=1])), -1) < 0

then 'decrease'

else 'null or same'

end end

In my shape calculation but it seems to work only for the first 2 colums and not for the percentage differences. help?

NOTE: My columns have only "Measure names" so I don't have multiple marks

• ###### 1. Re: I would like arrows for my all my measure values

It 's quite difficult to understand your expectation without seeing data structure.

Could you please create mock-up data and attach as twbx, and explain your expected view by number example.

Thanks,

Shin

• ###### 2. Re: I would like arrows for my all my measure values

Hello,

I understand I will try putting up an example at the earliest.

But,

Simply put I need a calculation to calculate the difference between the normal integer values and the percentage values in the table. So that I can put it to shapes for a KPI Indicator. (up and down arrows)

Currently, it is just calculating the difference between one cell and its previous value for the normal integer values.