What i want to do is add a count value to some of my report detail, for example in my takings report where i have the different vouchers listed and their value i want to also know the number of vouchers taken, for card sales i want to know the number of card transactions made etc etc
i saw another post where someone had asked something similar and i used the tag that was given, however that tag just gives the total monetary value and not the transaction count
This is what i used for one of my voucher lines in my report:
[Vouchers:5, 3, 5]
>>Tender Type|Count|Value
Voucher £5 OFF|[=F(TN('{REPORT CALCULATION TOTAL:(CT=Voucher Discount £5)}'),'0')/-5]|£[=F(TN('{ACCOUNT TOTAL:Voucher - £5 OFF}'),'0.00')]
I realised that {REPORT CALCULATION TOTAL} was giving me the total value of the vouchers, eg i process three £5 vouchers and the report was showing £15 instead of 3 and also was showing a minus number, so i added /-5 so that the expression now gave me a positive number for the amount of vouchers used. This works ok as this voucher is always £5
I know i havent used the correct tag and i cant use the ‘workaround’ for my 10% discount voucher as the monetary value of 10% would always be different. I also want to track the number of card transactions processed, the number of customers discounts processed etc etc as well as the total value
Can someone tell me the correct tag/format to show the number of different types of payments/calculations taken, not just the monetary value
ive highlighted below how i want it to look in the report and you can see the output for my £5 voucher as explained above