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 |
---|---|
33 | |
30 | |
30 | |
19 | |
16 |