Add multiple (yes)

[Daniel_Arguello]

good day
I have 3 enum columns, which have a value (yes or no),
if the value is “yes” create a virtual column to replace the “yes” by a percentage number (with an if formula), and then I made a fourth virtual column to add the 3 virtual columns above,

my question is if it is possible to have only one virtual column that sums the percentages of the real columns depending on the state of “yes or no”, try with “sum” and sum the 3 if expressions, but it does not allow me.
Beforehand thank you very much.

[Marc_Dillon]

This?

IF(...)
+
IF(...)
...

[SkrOYC]

Daniel_Arguello:

and then I made a fourth virtual column to add the 3 virtual columns above

This one works without problems?
You just need to replace the [NameOfVC1], [NameOfVC2], and [NameOfVC3] in the expression for the same expressions that you have today on each of the app formulas of the 3 VC