+2
Dear Community,
I need to set an expiration year.
I am using the formula “Year + 10” on a Metric with only Year Dimension.
I would like this to be more friendly to the end user.
I would like to set a metric that i can add to year (ex= Year + “metric”) . I tried with a metric with no Dimensions with a value 5. It did not work.
The end is for the user just by changing the metric at the “metric” would change the Expiration Year.
Best answer by Mat
View original
+5
Hi Rocco,
You should be able to do this with a metric, make sure that your offset metric is of type ‘Integer’. Pigment won’t allow for the possibility of a fractional number being entered for your offset, which is why it’s not currently working.
I hope this helps!
-Mat
+6
Hi
After that, you can create Expiration Year Metric with Year Dimension and Data Type will be Dimension Data Type and Apply Formula Year + ‘No of Years’
Hope your query is solved.
+2
both of your answers
+8
Thanks
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
