1 Reply Latest reply: Jan 23, 2018 11:57 AM by pradosh thakur RSS

    Subtracting Two Fields within a sheet

    Anthony DiMascio

      I have a sheet that brings in data from two tables - both tables have an "amount" field.

       

      Does anyone know how to subtract data on the fly while the report is rendering in the UI? This is not something that can be done when loading from the DB because you will not know which rows will be compared until the report is run.

       

      I feel like using measures would work but I am unsure of the syntax...all example I see are aggregate functions (SUM, MIN, etc.)

       

      Thanks