Confiform Field type Currency can not calculate by SQL Table Transformer

[Alice Liu]

Hi there,

With community's help, I use Confiforms TableView as source table and Table filter, table transformer macro with SQL to do difference comparison of two columns of source table.

However, I found that the value of "currency" Confiform field type can not be calculated, while "read-only" with value comes from "set expression" rule definition from other field s can.

The structure and issue illustration is as below image shown. Those with empty in the red circle, the field type is currency.

Wonder if there would be a solution to make currency field also computable?

Thank you.

# Previous post discussion for subtraction structure:

https://community.atlassian.com/t5/Confluence-questions/Table-transformer-How-can-I-subtract-filtered-data/qaq-p/2371897

[Alex Medved _ConfiForms_ · Accepted solution]

Hi @Alice Liu 

When you put the ConfiForms Field macros to show currency fields then make them transformed to numeric only values

In a field name parameter put something like (assuming the field name is mycurrencyfield)

mycurrencyfield.value

So, further down the TableTransformer sees it as a numeric value (without a currency prefix)

Alex

[Alice Liu]

Hi Alex,

It works, thank you!