Good Morning.

I have to calculate a percentage based on given values. I send you code extract. It is not working for me. I do not know if it’s a parenthesis problem or that I’m not using the formula’s options correctly:

measures: [

{ uniqueName: “CUPS”, aggregation: “count”, active: true },

{ uniqueName: “finalizadas”, caption: “Finalizadas”, aggregation: “sum”, active: true },

{ uniqueName: “anuladas”, caption: “Anuladas”, aggregation: “sum”, active: true },

{ uniqueName: “Progreso”, caption: “Progreso”, formula: “((sum(‘finalizadas’) + sum(‘anuladas’)/100)*count(‘CUPS’)”, active: true },

Can you help me with this topic? It is crucial for the progress of the project.

Hello Jose,

Thank you for the question.

Your formula looks correct, and it seems working for me. Please take a look at the following sample, it has different measures, but still, the formula is the same: ((a + b) / 100) * c – http://jsfiddle.net/flexmonster/1fvs863v/

Or do you mean that some values appear, but you expect them to be calculated differently?

Regards,

Ian

Thank you very much.

I have detected the error. In the formula the value of count (‘CUPS’) does not have to be the value of the row. I have to get the total value of the count column (‘CUPS’).

How do I trade against the total value of the column?

Thank you very much.

Hi.

How do I comment? I send you (attached) an example of how I need the formula to be. Because it’s a bit urgent. I have a presentation tomorrow Friday and I would like to have the calculated column mounted.

Sorry. Solved.

Hello, Jose,

We are glad to hear your question is solved.

Regards,

Tanya