Expression

[evansabres]

I have an expression

=SUM({$<promoCDE={"ADULT"},}>}[Net Sold Qty]) * [Ticket Base Price]

I do not get an error message when i enter, however in the table, the result is '-'.

The expected result would be a number.

Do I have the expression formatted incorrectly?

[evansabres]

I am able to enter the expression, however the result is still '-' in the table when I do this

[krishnacbe · Accepted solution]

What is the Dimension you have used? Actually the first part of your expression result will be one value and Ticket Base price has many values that is the reason you are not getting the result.

Share some sample data with all dimensions you use and expected Output