Generic Inquiry-How to ignore grouping on column

Hi  @larryly,

If possible, can you please share the XML format of the generic inquiry?

@Naveen B    I attached the GI file.  My other thinking is join the msrp to main table after grouping. But I don’t know to do it on GI. 

@larryly  Since all are same, you can use MAX/AVG  with this grouping will ignore for RecPrice..

If you are using grouping on your GI look out for numeric fields since the aggregate function will default to SUM if left blank. As @wfilipiak67 suggested,AVG will be your go-to if all values are identical and you want it to remain unchanged.

Thank you so much. It’s working.  I learned a lot from you all. 

@larryly what I do is set the results grid data field in the GI to =[Item.RecPrice]. 

This is effectively a very short equation that says just print that value and the best part is even when grouped the aggregate function will not apply to it. 

@abrunner78 You are right. I tried it. It’s working. It’s a good point that use some expressions on column to ignore grouping. Thank you!!