HELP for creating dynamic calculation

sorayavalencia22 — Thu, 11 Nov 2021 10:36:59 GMT

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

Re: HELP for creating dynamic calculation

abhijitnalekar — Fri, 12 Nov 2021 10:02:14 GMT

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)

topic HELP for creating dynamic calculation in App Development

HELP for creating dynamic calculation

Re: HELP for creating dynamic calculation