Hi,
I have an amount column which should be positive for some transaction types and negative for some other transactions. Can I put a conditional value format to do the same ?
Something like this -
{% if legacy_trans_type._value == ‘XFER’ %} -1 * {{ amount }} {% else %} {{ amount }} {% endif %} ;;