Variable and Set analysis

[alec1982]

hi all,

trying to set a variable with the following expression

Set vYFactor = if(GetSelectedCount([X_Factor.Location])=0, only({<[X_Factor.Location]={"=$(vAverage)"}>}[X_Factor.Storage Paid]), only([X_Factor.Storage Paid]);

when I try to present it in a text box I dont get any value

any idea?

[alec1982]

the last expression you sent has errors in it

[sunny_talwar]

Yup forgot to remove the end part

LET vYFactor = 'If(GetSelectedCount([X_Factor.Location])=0, Only({<[X_Factor.Location]={"=$' & '#(vAverage)"}>}[X_Factor.Storage Paid]), Only([X_Factor.Storage Paid]))';

[alec1982]

i still see extra # on it

[sunny_talwar]

LET vYFactor = 'If(GetSelectedCount([X_Factor.Location])=0, Only({<[X_Factor.Location]={"=$' & '(vAverage)"}>}[X_Factor.Storage Paid]), Only([X_Factor.Storage Paid]))';