Does there exist a way to take the commentary (a metric of type text) from across two different tables? For instance, commentary about an Opex Expense related expense, for example Travel Expense (table 1) and Employee Expense (table 2). Each table has a different set of metrics and each allows for text entry to supplement the expense to provide additional detail. Downstream the request is to compile all expenses in a FPA view of all expenses entered across the company and then additionally to include the expense detail (text) with the relevant expense lines. Bringing the data from the two different tables is no issue as we can use the “+” operand to include data from both tables. This presents an issue when attempting the same with Text as the metric type of text does not accept Text as an arithmetic operand. I attempted to utilize & but that did not align properly to the relevant line items being planned. Curious if anyone else has come across this...
Page 1 / 1
This would be the ideal state with a single Commentary metric allowing for the compilation of all commentary across the three tables. This of course does not work from a formula standpoint however.
Hi
To merge text metrics, you would need a text operator “&” which will concatenate the text metrics. (you could add a & “ “ & in your formula to separate text form each metric with a space)
I believe this question is similar to what you are trying to achieve.
Hope this helps,
Issam
Great, thank you so much, that’s just what I needed!
Reply
Sign up
Already have an account? Login
Log into the Pigment Community
Single Sign-On Need help?
Login with Saml2 Log in with your Pigment accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.