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...
Best answer by Issam Moalla
View original