HELP for creating dynamic calculation

[sorayavalencia22]

Hi!

I need some help in creating dynamic calculations:

- I have a variable input which displays a dropdown with the headings of  columns from a precharged table (Excel)

- With the variable input I can select one of the columns but I need to multiply that result with an other selected column  

For example: If I select in the dropdown column "E" wich contains results (in numbers), and I select from an other variable input a x%, I need these two columns to be multiplied and add the result in a table within the dashboard. 

¿Does someone know how to do this?

Regards,

Soraya

[abhijitnalekar]

Hi @sorayavalencia22 ,

You can multiply variables which are set to these dropdowns eg.

Variable1 is set to PESOCOMPETENCIA1  and Variable2 is set to COMPETENCIA1

Then you can use below expression in the table

$(Variable1)*$(Variable2)