Skip to main content

Hello team.

I hope everyone is well and still keeping strong.

I have a question and I hope someone can help me.

is there a way to add the following 2 totals up?

 

Hello @mc37, on top of my head, I can think one simple solution, you can add one more column in the GI as Total which should be a sum of NetSale and Cost. And set the Total Aggregate Function to the new Total column and you should be seeing expected result. 

Hi @mc37,

you can not add sum values directly in Generic Inqruies.

As @Vinay K  said, you need to add one more column that will display sum of (Net Sale + Cost) and add the Total Aggregation for the newly added field.

Attached sample screeshot for reference.

 

 

Reply


Terms & ConditionsCookie settings