Avatar

Level 7

OK, let's look at what the code is doing one line at a time.

var Y; initialize a variable "Y"

var Z; initialize a variable "Z"

Z = Table1.FooterRow.GrandTotal.rawValue; set the value in that cell to "Z"

Y = Nett_Pay.rawValue; Are you typing this in? It seems like you would want that filled in by something else. Each picture I've seen shows this field empty.

Y = Replace(Y,"Dolars","Rupees"); right now, Y is null, so there's nothing to replace.

Y = Replace(Y,"Cents", "Paise"); still null, so this doesn't do anything, either.

Nett_Pay.rawValue = Y; Y was null, so now Nett_Pay is null, too.

Maybe you want this:

var Y;

Y = Table1.FooterRow.GrandTotal.rawValue; I'm guessing that this is a currency value, so...

Y = Replace(Y, "Dollars","Rupees");

Y = Replace(Y,"Cents","Paise");

Nett_Pay.rawValue = Y; place the currency value into this field with dollars changed to rupees and cents changed to paise.