Generic Inquiry - total of amount by employee for selected subaccounts

Hi @bfryett,

Have you tried something like this?

1. 
   =SUM(IIf([SubAccountField] <> 1, [AmountField, 0))

2. 
   In Grouping tab add the Employee ID field to group the records by Employee.
   
   Hope, it helps!

If you are using the grouping tab, it would probably help for clarity of your GI to try using ​Dipak’s formula simplified to =IIf([SubAccountField] <> 1, [AmountField, 0)) and put the “Sum” in the aggregate function column within the formulas row in the results tab.

Thank you both.  This was an existing Generic Inquiry put together with some custom tables quite a while ago.  On closer examination the table structure was making it difficult to include all the required information in the one Generic Inquiry - Amount was pulling from one table and Total Amount from another.  Although a bit counterintuitive the simpler solution was to set up two GIs to pull the required information by employee and then use the Grouping correctly.  The information was then summarised using the pivot table function.  So, I did pick on part of your suggestions once the table structure was sorted.