Show a math operation on screen

Hi im trying to make an operation based on data filtered on screen, check screenshot below.

I have 2 chart filtered by date on screen and i want simply make “total A - Total b= profit”

How i can do that?

Math operations happen in the data editor. Then display the result with a component in the display builder.

We need to be able to see the data structure but the following quickly occurs to me:

  • create if column and condition when the date to be filtered matches the date of the data row show the amount

  • create a rollup sum towards this column, so that it shows the result of the filtering

1 Like