Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Try this
=SUM( { $<promoCDE= {'ADULT'} } >} [Net Sold Qty] ) * [Ticket Base Price]
Try to remove the comma highlighted below and check
=SUM({$<promoCDE={"ADULT"},}>}[Net Sold Qty]) * [Ticket Base Price]
The expression dialogue box gives an error message, 'Error in set modifier expression'
I unfortunately get a result of '-' in the table when I do this
Try this
=SUM({$<promoCDE={"ADULT"}>}[Net Sold Qty]) * [Ticket Base Price]
I unfortunately get a result of '-' in the table when I do this
Can you share some sample data or Dashboard to fix the Expression
Ohh this is right
=SUM( { $<promoCDE= {'ADULT'} >} [Net Sold Qty] ) * [Ticket Base Price]
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