AlexJanetzky
New Member
- Joined
- May 4, 2023
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
I have a table such as the one below and this is linked to a dashboard where I have used the following formula to return the value of the last period: =INDEX(BM33:DF33;AANTAL(BM33:DF33)-1) (this works)
In the dashboard I also want to show the value of the previous periode, in this case P2 and have used the following formula: =INDEX(BM32:DF32;AANTAL(BM33:DF33)-1)&": "&INDEX(BM33:DF33;AANTAL(BM33:DF33)-1)
The formula works but it doesn't return the value as a percentage but as "P2: 0,06", and I would want to see "P2: 6,0%)
Can someone please help me with this?
Regards,
Alex
In the dashboard I also want to show the value of the previous periode, in this case P2 and have used the following formula: =INDEX(BM32:DF32;AANTAL(BM33:DF33)-1)&": "&INDEX(BM33:DF33;AANTAL(BM33:DF33)-1)
The formula works but it doesn't return the value as a percentage but as "P2: 0,06", and I would want to see "P2: 6,0%)
P1 | P2 | P3 | P4 |
5,2% | 6,0% | 8,3% |
Can someone please help me with this?
Regards,
Alex