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?

[its_anandrjs]

Try this

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

[krishnacbe]

Try to remove the comma highlighted below and check

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

[evansabres]

The expression dialogue box gives an error message, 'Error in set modifier expression'

[evansabres]

I unfortunately get a result of '-' in the table when I do this

[krishnacbe]

Try this

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

[evansabres]

I unfortunately get a result of '-' in the table when I do this

Expression

[krishnacbe]

Can you share some sample data or Dashboard to fix the Expression

[its_anandrjs]

Ohh this is right

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

[evansabres]

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

promoCDE = ADULT, NET SOLD QTY is a numeric field, such as 2, where as [Ticket Base Price] is a monetary filed, formatted such as 0.00