3 Replies Latest reply on Nov 25, 2016 6:19 AM by Abhishek Yadav

    Parse value before showing in filter

    Pascual Bayo

      Hi,

       

      I've got a table where I store some fees. They are saved as negative amounts. For example:

      - Merchant1, fee: -30, fee_type: AAA

      - Merchant2, fee: -14, fee_type: BBB

      - Merchant2, fee: -14, fee_type: BBB

       

      I want to show a filter in my sheet where I search for fees amounts. Obviouslly, if I put the "fee" field within the Filters shelf, it reads the negative numbers, but I want it to display it as positive.

      So, the question is: is there any way to "process" the values in a filter before it shows them?

       

      Thank you very much!