I have an app that creates a report from an automation. we are using it to invoice our suppliers. Some suppliers have fuel surcharge and are asking to have that on a separate line item. We have it as a column and need it to stay that way. They are asking for the report to create another record with fuel surcharge only.
I might suggest the following in your template:
Fuel Surcharge summary
<<If: ISNOTBLANK(TableNameFromStartExpression[FSC])>>
Create a separate table here using the same info here
<<EndIf>>
User | Count |
---|---|
41 | |
25 | |
25 | |
17 | |
12 |