Having the correct data type is important when working in Pigment. Especially when writing formulas, depending on the syntax of Function, you might need to adjust the data type. Below is a table letting you know which functions can help you achieve this.
Original Data type | Converted data Type | Function used |
---|---|---|
Date | Number Integer | |
Date | Dimension | |
Numbers or Integers | Date | |
Numbers or Integers | Text | |
Text | Number Integer | |
Text, Numbers, or Integers | Dimension | ITEM |
Text | Date | |
Dimension | Text | Dimension.Name - Reference the Name property of the Dimension |