Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You want to divide Values1 by TMB1?
If is that you can try :
Values1
/$(TMB1)
on Straight Table expression.
Regards,
Aurélien
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
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?
Are you reloading your app, when you change the value?
Because, you´re calculating those values at script level
Hi,,,
Yes i am reloading
and i tried same problem in front end expression using table box,same problem i am facing
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