on 12-17-2015 11:24 AM
I'm creating a report to produce weekly statistics which calculates how much re-processing failures will cost. Because the amount changes the user must enter an amount, which can then be used in the calculation.
Example £25.00.
Is this possible.
many thanks
Jane
Hi Jane,
This can be achieved by creating an input ready formula variable. Add a key figure structure and create a formula, edit the formula and then in the bottom left create a new formula variable, then edit this. Make sure it is input ready and select the correct data type.
The add this formula variable to the formula and multiply by the key figure which contains the number of failures.
If you need more detailed instructions then please let me know.
Thanks
Mike
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mike
Thanks for the answer. The good news is the amount can now be entered, the bad news is when I run the query only the amount is being displayed and none of the other key figures on the report.
Key figures
Validated count
authorised count
Failed
Cost of failure calculated using amount entered multiplied by failure count.
structure
amount created formula variable
Thanks
Jane
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.