I’m trying to populate the very last column of the below Transaction list, which is set as dimension, which is already defined. I could populate the column line by line by selecting the values from the dropdown but there are lots of lines.
That’s why I’m trying to use a formula to populate the dimension via formula.
The formula should bring the text from the Entity column (set as a dimension) and concatenate with the result with an if statement aiming to provide “Account code” text column (circled) in case it’s’ populated, or in case “Account code” is blank provide the “Account name” text column (highlighted in blue)
if (Transactionlist.AccountCode = “”,Transactionlist.AccountName,Transactionlist.Accountcode)
The result should be: Entityname2202 or EntitynameBank
Thanks for your help.
Best answer by francoisView original