Year + 'Metric'

  • 4 July 2023
  • 4 replies

Userlevel 2
Badge +2
  • Budding Pigmenteer
  • 6 replies

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 4 July 2023, 18:06

View original

4 replies

Userlevel 3
Badge +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!



Userlevel 4
Badge +7

Hi @Rocco 

​​​​@Mat  is right. First, You will have to create a ‘No of Years’ metric with Data Type Integer and No Dimension.

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.

Userlevel 2
Badge +2

both of your answers @abhilashsawla & @Mat are perfectly on point, thank you for the help

Userlevel 5
Badge +8

Thanks @Mat  & @abhilashsawla for the lighting fast help here! 🙌