Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using the below expression in my table
if([Table Source]=('WHINH301') and ("T$LTRL"=1) and ((len(trim("T$BOLA"))>0)),Sum({<[Ship_Date_GMT_Updated]={"<=$(vLastmonthdate)"},[Arrive_Date_GMT_Updated]={">$(vLastmonthdate)"}>} Quantity)
,if([Table Source]=('WHINH301') and ("T$LTRL"=2) and ((len(trim("T$BOLA"))>0)),Sum({<[Ship_Date_GMT_Updated]={"<=$(vLastmonthdate)"}>} Quantity)
))
But when I remove a field named [SHID] my Quantity value changes, even though I haven't used [SHID] on my front end.
Can anyone tell why?
Where are you removing [SHID] from, is it a dimension in your chart? a filter applied?
I am removing SHID from my table visualization.
Yes, it is a dimension in my chart.
that means your values are simply aggregating at a different level now,
also do not use keyfields in your charts