Calculating data

Hello everyone,

I’d like to know if it’s possible to make a form so that when the user enters all their fields, a calculation is made with the fields they’ve filled in to put them in a new column?

I have a table with 5 columns:

  • Dependency
  • Penetration
  • Maturity
  • Confidence
  • Threat

The user can only enter the first 4 columns, but the last column will be the result of a calculation:
Threat = (Dependency * Penetration) / (Maturity * Confidence)

Is it possible to add this calculation to the form invisibly for the threat column?
I know it’s possible to do this in postgresql but I can’t see how to do it via the Ignimission platform…

This is possible by using virtual column, all informations are available in the documentation link below :