help variable values

[Laur1987]

Hi.

I have a project. A perfum store. The client wants to forecast the profits by the price of perfums. The price of perfums depends by the quantity of Ethanol and Perf Oil. How I can make that?

I made the calculator with slicer. (see attach) But I have to do the forecast now. Like in example below there is the production costs which included a static price of the perfume like R55.

So I need the price to be variable for this dashboard. When I change the price in the total bottle cost, to change the production cost. I tried with lookupvalue because I don t have relationship but is not working.

Thanks in advance.

@amitchandak @lbendlin @Greg_Deckler @Ashish_Mathur