This content has been marked as final.
Show 4 replies
-
1. Re: Creating a ratio using items within the same dimension
Jim DehnerJun 20, 2018 3:21 AM (in response to Philip Donnelly)
1 of 1 people found this helpfulGood morning
see the attached
as a formula try this
it returns this
it uses this table calculation as the base
then open the green pill (the calculation will default to previous value)
then pull the pill off the shelf and move to measure - you will see the formu that you can modify to meet your needs
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
-
2. Re: Creating a ratio using items within the same dimension
Philip Donnelly Jun 20, 2018 3:25 AM (in response to Jim Dehner)Thank you very much for the speedy reply Jim. I will give that a go, and then confirm if that does the trick.
Cheers
Philip
-
3. Re: Creating a ratio using items within the same dimension
Philip Donnelly Jun 20, 2018 4:28 AM (in response to Philip Donnelly)Thanks Jim, that has had the desired effect.
Philip
-
4. Re: Creating a ratio using items within the same dimension
Jim DehnerJun 20, 2018 4:33 AM (in response to Philip Donnelly)
Glad to help out
Jim