Hi!
I’m having issues with a formula. My formula is currently looking like this:
The result I get is the error message Function error: function IF argument 2 and 3 need to have the same type. Any idea of what I need to do to get the dummy name in the CC# column?
Best answer by Issam Moalla
Hi
The error here is due to a data type mismatch: You need to have the 2nd argument and 3rd argument result into the same data type as your target property here CC #.
‘Cost Center GL’.’CC Concatenated’ = ‘9999 Dummy CC”‘GL test’.’CC (Load)’will result in attributing the same data type as the property CC (Load) which in your case is the Cost Center dimension.
Since your target property has a Cost Center dimension data type as well you would need to adjust the 2nd argument.
To achieve the logic you are looking to apply the 2nd argument could reference the item directly within the Cost Center dimension directly:
'Cost Center GL'.'CC Concatenated'."99999 Dummy CC"This would result in the Cost Center dimension data type.
hope this helps,
Issam
+11Hi
The error here is due to a data type mismatch: You need to have the 2nd argument and 3rd argument result into the same data type as your target property here CC #.
‘Cost Center GL’.’CC Concatenated’ = ‘9999 Dummy CC”‘GL test’.’CC (Load)’will result in attributing the same data type as the property CC (Load) which in your case is the Cost Center dimension.
Since your target property has a Cost Center dimension data type as well you would need to adjust the 2nd argument.
To achieve the logic you are looking to apply the 2nd argument could reference the item directly within the Cost Center dimension directly:
'Cost Center GL'.'CC Concatenated'."99999 Dummy CC"This would result in the Cost Center dimension data type.
hope this helps,
Issam
Hi
Having an issue with this again. Trying to set a new column with Revenue category ID and Spend category ID. Most lines either has a value in those columns, but I’m not able to conjoin them into a new column. Can you tell what the error could be in this instance?
+11Hi
Here you have same error: your property accepts one type of result and in your formula you are mixing two different dimensions.
In the IF statement if the condition is true you would generate a Revenue Category ID , If it is false the result would
be Spend Category ID However your Target Property would have one specific data type either Revenue Category ID or Spend Category ID it can’t be both.
If you want to achieve this logic, you need to apply the following:
Hope this is helps,
Issam
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.