when i have calculation in advance pdf for currency, the output will not treated as currency anymore, what is the best approach to still retain / cast the calculation result still as currency

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that when you perform calculations in an Advanced PDF for currency, the output is not treated as currency anymore. To retain or cast the calculation result as currency, you can use the

?string.currency

Freemarker built-in function. This function formats the number as a currency amount. Here is an example of how you can use it:

code
${(-record.discountrate * record.subtotal)?string.currency}

In this example, the calculation

-record.discountrate * record.subtotal

is performed and the result is formatted as a currency using

?string.currency

. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******