Variables

[hobanwashburne]

Why does

x = sum( {< FiscalYear = {2013} >} (NetSales * SalespersonPercentage/100))

y = sum( {< FiscalYear = {2012} >} (NetSales * SalespersonPercentage/100))

sometimes not work, but

x = sum( if(FiscalYear = 2013, (NetSales * SalespersonPercentage/100)),0))

y = sum( if(FiscalYear = 2012, (NetSales * SalespersonPercentage/100)),0))

does as a Variable Definition when used in a Chart Expression as $(x)/$(y)?

Either one work and are equal when used alone

[Anonymous]

Hi Scott,

When you have selected FiscalYear 2014, your expression will not work. You use $(x) to evaluate the variable on object.

I think that is better:

x = sum( {< FiscalYear = {'=$(=Max(FiscalYear))'} >} (NetSales * SalespersonPercentage/100))

y = sum( {< FiscalYear = {'=$(=Max(FiscalYear)-1)'} >} (NetSales * SalespersonPercentage/100))

When you add values on Set modifier, is better use simple commas:

x = sum( {< FiscalYear = {'2013'} >} (NetSales * SalespersonPercentage/100))

y = sum( {< FiscalYear = {'2012'} >} (NetSales * SalespersonPercentage/100))

Kind regards.

[hobanwashburne]

Thank you for the response, however it is not working in my problem application. I have created a Test application with three identical charts. In the fist I calculate everything in the object, Chart A uses variables and set analysis, Chart B uses variables and an "if statement".

Everything seems to work in the Test application attached, however in the application that I am editing Chart A fails on the % column, it only displays "-".

Also you may notice the field FiscalYear has been changed to YEAR to match the problem application. I thought that because year was also a command it may have been the issue. However, as you can see on the attachment it seems to function in the Test.

[sunny_talwar]

I think the issue might be related to the fact that the Year is coming from another table compared to SalesPersonPercentage. I am not 100% sure what the issue is, but set analysis seems to not work under some cases when the data is coming from different tables. I am not 100% sure, but may be swuehl can enlighten us

[swuehl · Accepted solution]

If you remove the label from your percentage expression and then hover with the mouse of the expression column header, what do you see with the variables expanded? Could you make a screen shot and upload?

Besides this, does your problem application show the exact same data model or is it different?

[hobanwashburne]

Thank you, this was incredibly helpful and I believe that I have discovered the problem.

Here is how the original application looked:

Here is what I wanted to change it to (which now functions):

My mistake was rather than replacing the expression I commented out the original expression and added mine below it:

Which resulted in the following failed expression:

[swuehl]

Glad that you've got it sorted out.

That's what I've assumed, that your variables expand to something that is not a proper expression.

Comments in variables are likely to mess up expressions that are made of a combination of variables.

I usually only enter a label in the expression header after my expressions are working correctly.

Regards,

Stefan

[sunny_talwar]

I usually only enter a label in the expression header after my expressions are working correctly.

Nice advice. I will keep that in mind as well. Thanks for helping Stefan.

Best,

Sunny