• 11 April 2023
  • 2 replies

Userlevel 3
Badge +2
  • Seasoned Pigmenteer
  • 14 replies

Hi Team,

Please suggest me a way to calculate the difference between Income (List item) and Total Expense (Calculated item) in order to calculateate EBITDA.

Screenshot attached below for your reference.


2 replies

Userlevel 4
Badge +7

Hello Nancy,

Have you tried creating a dedicated Metric to run your calculation for EBITDA by using the SELECT modifier to select “Income” amount and rebuild “Total Expense” with a formula to calculate the difference in your Metric.

Let me know how it goes :) 

Userlevel 5
Badge +8

Hey Nancy,

Did you manage to do the calculation? :)