Skip to Content
0

Change a dimension to a measure

Jun 26, 2017 at 06:56 PM

39

avatar image

Hi

Is it possible to change a dimension (string) to a measure. I want to use relative value but I understand that I can only do that with a measure or detail object? If so, can you explain the steps involved.

Thanks Will

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
AMIT KUMAR
Jun 26, 2017 at 08:57 PM
0

This is not about object type (measure or detail) but depend on the datatype.you can not use relative value function with string data type.even if it convert to measure variable it won't work.

you need to convert data type to number to use relative value function.if all values are numeric then use tonumber function to convert in the number

Share
10 |10000 characters needed characters left characters exceeded