I’m trying to turn the attached Table into a GI, however, some of the fields I’m not sure how to convert. I’m not even sure how the fields “=IIf([@ReportFormat] = 'D', $TotalQtyByLayers, $TotalQty)”/ “=IIf([@ReportFormat] = 'D', $TotalCostByLayers, $TotalCost)” or how they would be reproduced in a GI? Is there a possible way to create this?
Question
How to turn this table into a Generic Inquiry?
+4
The values with $ in front of them are variables and you can see what these are by clicking on the Details section then clicking the ellipses on the Collection and you’ll see the window of variables and which calculations make up the variable:
The values with $ in front of them are variables and you can see what these are by clicking on the Details section then clicking the ellipses on the Collection and you’ll see the window of variables and which calculations make up the variable:
Ah, yep, there they are.
However, using the field listed brings in larger values than I’m expecting. I don’t see a filter anywhere either that would be lowering the result.
Hi
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.