We always collide Thats good
Thanks for this.
How do you get the arrows to appear in the cells? As it stands I have only got a variation of coloured numbers.
Alex, add this calculated field to Label and adjust the Label to be shown Side .
If you are still facing issues, Please share your workbook .twbx file with sample/fake data.
Rasa Raza Thank you so much, you have been really helpful.
Can I ask you on further question regarding this;
I want the formula to identify figures that show no change differently to those that increase or decrease.
As it stands no change quarter on quarter appears with ▼
I would like it to appear in a different colour with ▶
Due to the sensitivity of the information I cannot post the attachment; I will post all the pictures that relate below and hopefully you can help with that.
Current KPI formula;
Worksheet using current formula;
I am not skilled enough to write formulas at all.
Highlighted in red is what I am trying to overcome. Quarter on Quarter data hasnt changed, but it is idnetified as a decrease. I want to add to the formula above to identify no change in a different colour with the following sign; ▶
1 of 1 people found this helpful
Did you try the below formula ?
if INDEX() = 1 then
if sum([Measure]) > LOOKUP(sum([Measure]),-1) then
ELSEif sum([Measure]) < LOOKUP(sum([Measure]),-1) then
Perfect, thanks for your help!!!