I am looking to add a condition to the below expression so that it pass the parameter of a region field. (the sum of sales for the selected region should be added to the below expression)
=sum({<Region={'$(Region)'>}Sum([Time to complete])/Sum(Total [Time to complete])*Sum(Resource))
I tried the above expression. However, not getting the desired output.
The syntax $(Region) would refer to a variable, not a field value. To include the selected Region, remove the entire Set {} expression. Including selected data is the default.
