Can formula expression be automatically converted into meaningful textbox.?

Sreekumar_Analytics_Ambassador

In other analytic product we have this feature as shown below that converts formula expression into textbox.

Gabby Rubin-Oracle

The screenshot shows that the formula outcome is the string shown in the big box. The big box does not convets the calculation, it is just showing the value. Using the CONCAT function, you can create a similar expression in OAC/OAS. In this case, the function will be something like:

Concat(Concat('Financials as of ', MONTHNAME(CURRENT_DATE)), Concat(' ', cast(year(CURRENT_DATE) as char(4))))

(I did not do the relative month calc as the question was about the textual function)

Sometimes, it is cleaner to use REPLACE as you can write the full templated sentence and don't need to concat string parts that are not values.

REPLACE(REPLACE('Financials as of MMM YYYY', 'MMM', MonthName(CURRENT_DATE)), 'YYYY', cast(year(CURRENT_DATE) as char(4)))