cancel
Showing results for 
Search instead for 
Did you mean: 

Bex Query input an amount parameter

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member213692
Participant
0 Kudos

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

Former Member
0 Kudos

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

former_member213692
Participant
0 Kudos

Hi Jane, sorry you should be able to add the key figure to the existing key figure structure rather than adding a new one, hopefully that should do it!

Former Member
0 Kudos

Hi Mike

Thank you, that has worked perfectly

Jane

Answers (0)