Set Analysis Behaviour

[shannoypaul]

TenderAddedFlag 0,1

TenderRemovedFlag 0,1

I am creating a Bridge Chart.

Expressions:

Current Tender Value - Sum(DISTINCT [Current Tender Value (USD)])

Tender Removed - Sum({<TenderRemovedFlag ={1}>}DISTINCT [Volume Change Value (USD)])

Volume Change - Sum({<TenderRemovedFlag ={0},TenderAddedFlag ={0}>} DISTINCT  [Volume Change Value (USD)])

Tender Added - Sum({<TenderAddedFlag ={1}>} DISTINCT [Volume Change Value (USD)])

New Tender Value - Sum(DISTINCT Next Tender Value (USD)])

Issue - Tender Added expression is never displayed

[#2]

Hi

Do you have values populated in TenderAddedFlag  with 1

[sunny_talwar]

Have you converted your chart into a straight table to see if there is any value for the expression or is it just not showing anything on the chart. Would it be possible to share a sample to see the issue?

[shannoypaul]

Attached Sample Data.

Kindly Ignore the bridge, If I need to display all bars at a time using the expressions.

[tresesco]

If I filter your excel sheet to _TenderAddedFlag -> 1, I get blank Volume Change Value (USD) column. So sum(Volume Change Value (USD)) with that filter would generate zero.

[shannoypaul]

Got it, For Tender Added Flag, Volume Change is always null hence the calculation out puts zero