Expression Not Displaying Value

[evansabres]

I have created a chart with several dimensions and expressions. I am attempting to add in a relatively simple expression of =CURRENTPRICE however, when I apply the expression, not data is displayed.

When I add in an aggregation method such as MIN, MAX, SUM, etc. I get data. 

Any ideas on where I am going wrong would be helpful. I have attached my data model and below are the dimensions I am using as well as a small sample of what the table looks like

Game Date	Opponent	Tier	Price Scale	Price
9/15/19	ABC	1	Lower	-
9/15/19	ABC	1	Upper	-
9/15/19	ABC	1	Club	-
9/15/19	ABC	1	Suite	-

[dplr-rn]

I am assuming you have more than 1 value for CurrentPrice per row. If so that will not display the value and you need an aggregration function

i.e.  combination of Game,Opponent,tie,pricescale may have more than 1 currentprice

Game Date	Opponent	Tier	Price Scale	Price
9/15/19	ABC	1	Lower

[evansabres]

There should only be one CURRENTPRICE per row, based on the Game Date and Price Scale

Do I need to introduce a set expression? If so,  what would they structure be? 

[dplr-rn]

depends on your data. Share data sample similar to your actual data and i can try and help

[evansabres]

Hope this helps

[dplr-rn]

Looking at it i would check your data model. You have multiple columns with values for Price Scale

PPPRICESCALEDESC

PRICESCALEDESC

have a feeling something is messed up while you are loading and you haven't modeled it correctly.

Load this data into a sample app exaclty like your load script and share the qvf file if you can

[evansabres]

I have them labeled differently so as not to create a synthetic key and/or loop in the script. 

[dplr-rn]

Are you using the right column in your table?

Add the CURRENTPRICE column as a dimension and check. 

[evansabres]

When I add that field (CURRENT PRICE) in as a Dimension, the app generates an error of 'Out of Calculation Memory'

[dplr-rn]

that hints at a modeling issue .
As requested before Share a sample app with your exact load script and sample data. and i can check