Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
GrantBooth
Creator
Creator

Using set analysis in conjunction with variable

I've got some measures which are quickly getting unwieldy and I'd like to start using variables instead, however I've got some questions about using set expressions.

I have variable v.Amount which is very straightforward, -1*Sum( Amount)/1000

Is it possible to add set analysis and a variable in conjunction? What I mean is that I would like to be able to have

v.Amount for <ProductType = {'Budget'}>}, rather than typing -1*Sum({<ProductType = {'Budget'}>} Amount)/1000.

Using dropdowns isn't appropriate because there's instances of {<ProductType = {'Actual'}>}  and {<ProductType = {'Forecast'}>}  appearing on the same sheet

2 Replies
Digvijay_Singh

May be achieved using parameter in the variable - 

Variable 1 

Name - v.Amount

Value - -1*Sum( $1 Amount)/1000

Variable 2 - vsetExp

Value - {<ProductType = {'Budget'}>}

 

Expression in text box I tested -

$(v.Amount($(vsetExp)))

It shows - 

Digvijay_Singh_0-1633563244609.png in expression editor

 

 

 

GrantBooth
Creator
Creator
Author

Not able to get this one to work, the expression -1*Sum( $1 Amount)/1000 creates a error