How to make Formula in Variable

[eddykwan_]

Hi Everyone 

I want to ask about how to make Formula [Product Price] * [Product Sold] in variable 

I make a Variable product price and Product Sold after that i make formula in Variable Revenue, and i got a value is 0 and null 

Thank you 

[anat]

Why can't you try in backed script

[Prem0212]

Here i am giving an example. You have to use the variables in the expression like yellow marked in below image below. use the variable like  $(Variable that has defined by you)

Please accept the solution if u liked it.

[Rams-]

Hi,

I would suggest you to use this expression:

Sum([Product Price]) * Sum([Product Sold]) an create Variable

Here's the output fro your data:

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!