Null handling in front end for multiple expression and single dimension

[abhinayranjan11]

Hello All,

I am facing an issue in front end the users need that null for trip id 305 and 317 should be suppressed but since null is there for trip id 301 its k for this as boxes are not there for all location but if boxes gets empty in between the location before 6 its throwing null.Users don't need these nulls trip id can be anything.Pivot location wise weight variation of boxes.I am attaching the application here if anyone have opinion please comment and solve .Thanks.

[sunny_talwar]

You are looking for something like this?

Use this as your calculated dimension for Box and make sure to select 'Suppress When Value Is Null' on the dimension tab for Box dimension

=If(Len(Trim(ItemName)) > 0, ItemName,

If(Aggr(Count(TOTAL <TripID, VName, Time_Stamp> ItemName), TripID, VName, Time_Stamp, ItemName) = 0, Dual('-', 1)))

[abhinayranjan11]

only for these two in this app not for all means not for trip id 301

[sunny_talwar]

only for these two in this app not for all means not for trip id 301

huh?? Sorry, but I have no idea what you mean...

[abhinayranjan11]

I mean to say null should be suppressed for trip id 305 and 317 but the expected weight  and actual weight for these two trip id i.e Expected weight_loc3 and Actual Weight the 0 should not suppress , Expected weight_loc6 and Actual Weight the 0 should not suppress.on suppressing null by using dimension as expression u hv mentioned the ExpectedWeight_Loc3 ,ExpectedWeight_Loc6 the 0 should show on these location.As the empty truck move to these location so itemname(box) should come 0 for this in a single line.

[sunny_talwar]

I have no idea what you are looking to get... can you show me the expected output in an Excel file?

[abhinayranjan11]

[sunny_talwar]

So you want to see 0 in these two locations?

Is that the issue?

[abhinayranjan11 · Accepted solution]

yes that should come 0