Issue with Inputfield

[NavinReddy]

Hi All,

I have an issue

i have one inputbox and tablebox

if i enter 100 in inputbox it will calculate as per my equation in tablebox,

here i need to edit the values in values for that im using script in inputfield ,

here im facing the issue if i give 100 in inputbox its not working and it not calculating the values

Some one help me Please find the Screen shoot and QVW

Thanks ,

Niranjan

[Aurelien_Martinez]

Hi,

You want to divide Values1 by TMB1?

If is that you can try :

Values1

/$(TMB1)

on Straight Table expression.

Regards,

Aurélien

[NavinReddy]

yes ,but if i use inputfield in script ,

in dashboard if i enter values in inputbox tablebox values are not changing

help me

Thanks,

Niranjan

[Aurelien_Martinez]

Try this script:

LET Newspaper1=round($(TMB1)*2/100);
LET Onlineadvertising1=round($(TMB1)*20/100);
LET Searchspends1=round($(TMB1)*20/100);
LET Trailers1=round($(TMB1)*20/100);
LET Banners1=round($(TMB1)*1/100);
LET OOH1=round($(TMB1)*5/100);
LET Displays1=round($(TMB1)*4/100);
LET Theatrespends1=round($(TMB1)*5/100);
LET TVNational1=round($(TMB1)*20/100);
LET TVregional1=round($(TMB1)*3/100);

Movie1:
LOAD * INLINE [
Spends1,Values1
    Newspaper, $(Newspaper1)
    Online advertising, $(Onlineadvertising1)
    Search spends, $(Searchspends1)
    Trailers, $(Trailers1)
    Banners, $(Banners1)
    OOH, $(OOH1)
    Displays, $(Displays1)
    Theatre spends, $(Theatrespends1)
    TV National, $(TVNational1)
    TV regional, $(TVregional1)
];


INPUTFIELD Values2;
NoConcatenate
Movie2:
LOAD
  Spends1,
  Values2
Resident Movie1
;


Drop Table Movie1;

That you want?

[Clever_Anjos]

Are you reloading your app, when you change the value?

Because, you´re calculating those values at script level

[NavinReddy]

Hi,,,

Yes i am reloading

and i tried same problem in front end expression using table box,same problem i am facing 

[NavinReddy]

Hi All,

previous if i enter any value in inputbox it will share percentage wise

now if i enter any value in inputbox not working plz find the attachement

Thanks

Niranjan