You should try U1#Shipping_Trade.Base.Where(Text4 Contains Long_Lines)
You should try U1#Shipping_Trade.Base.Where(Text4 Contains Long_Lines)
Thanks it works well to have it at the finest level!
I think it is not possible to aggregate data in order to have the total of all Lines which have a Text4 as Long_Lines?
You could create a ud8 member and do it as a formula using dynamicentity agg function. Or even make that as an attribute dimension (keep in mind you'll lose a UD)
Do you work at my office? 😅
Because we already have a dynamic UD based on the Text4 and we used an UD for 2 separate hierarchy as we dont need to cross each of it at the same time.
But having it also in formule could have been a powerful tool also.
But I really appreciate your help!
