InputSum question

[jduluc12]

Hi,

I am using

INPUTFIELD Field1

in my load script and using

inputSum([Field1]) in the my expression.

I am able to enter the values for Field1 in the pivot table.

But this value changes by itself when ever i filter the chart.

I want to keep the value of Field1 unchanged.

Is there any way to do it?

-Jean

[Anil_Babu_Samineni]

Even, If i filter it's not changing the value. i am not sure, Whether this is version issue or something.. If not, Please update work file

[jduluc12]

I think you are right

i was using

inputsum(Field1, '*')

[Anil_Babu_Samineni]

* won't consider here. Use InputSum(Field1)

[jduluc12]

in fact, i will take my word back.

it is still changing.

it changes like this

suppose the initial value is 15 and this is how the table looks like

sales                    Field1              sales*(Field1/100)

1091753.25       15                     163762.99                    

And then i select some filter like date which makes sales as 26643.32

then the value of Field1 changes to 10.38

I want it to be 15 always.

[Anil_Babu_Samineni]

May be share application or images atleast. Before change and after change with filter?

[jduluc12]

Before

after date selection

The load script looks like

INPUTFIELD [Commission Rate]

and it is loaded as

0 as [Commission Rate], RowNo() as key

I added RowNo() because it was giving me "Duplicate keys when loading input field"

[Anil_Babu_Samineni]

Is this is simple, please post sample application

what if we are using this? InputSum({1}Sales) // Sales you need to change?