Input Box to change Amount

[ivandrago]

Hi,

I have the attached document, I have to Input Box

SalesFrom

SalesTo

When I entered a figure in both of the boxes I want it to filter the SalesAmount figure? I created to variables but not sure how to incorporate this so the SalesAmount figure changes.

Thanks

[#2]

Please check.

[deepakk]

hi

YOu can use it below way.

Sum({<AMount= {">= $(v1) <= $(v2)"}>} AMount)

where v1 and v2 are variables

[ivandrago]

Is it possible for a way to have it filter all the other fields

[ivandrago]

Hi,

Is this possible? Thanks

[stevedark · Accepted solution]

Hi Ivan,

This is possible. You just need to construct an expression and attach it to the selection criteria for the amount.

I have amended the previous version of your document to add a button which assigns the following to the selection:

='=SalesAmount >= $(SalesFrom) and SalesAmount <= $(SalesTo)'

I have also attached the same action to Triggers that are attached to the add and update actions of the two variables.

This should achieve what you are after.

Post back if you need further assistance.

Regards,
Steve

[deepakk]

hi,

copy paste this code to all the required expression.

{<AMount= {">= $(v1) <= $(v2)"}>}

[ivandrago]

Thanks Mark, that works great! It won't let me choose this as answer not giving me the option for some reason?