Use input box with calculated field

[alec1982]

Hi Guys,

I have a table with the following fields:

ID     Quarter     CurrentValue     PCT                        LL

1       3/2013          483              4.31%                    483

2       4/2013          483              4.31%                    504

3       1/2014          483              4.31%                    525

I used the following formula to create a new field named LL as follow

if( ID<>Previous(ID),CurrentValue,peek([LL])*PCT)+ Peek([LL])) ) as LL  ( The field is colored red above)

The requirement now is to have the PCT entered by the user into an input box and create a bar chart to show Sum(LL) by Quarter

The above script worked perfect if PCT is a static value on a column on the table. Not sure how can we do the same calculation inside a bar chart while PCT is entered by the user

Let me know your thoughts.. and thxs for help!

Best,

Alec

[#2]

Hi,

     If you dont want to use duplicate ID then why you are checking this: "ID <> Previous(ID)" because it showing that there are duplicate IDs and I am not changing only last value, I wrote expression according to your given expression . If your requirement is different then clear with one sample file or image.

Thanks and Regards,

Ashutosh

[#3 · Accepted solution]

Hi,

      check this file again and let me know.

Thanks,

Ashutosh