Loading Variables - Script line error

[nihhalmca]

Hi All,

I am trying to load variables from excel spread sheet by for loop however, getting script line error while loading.

Variable looks like vName = Num(Sum({<Type ={'A'}, Year = {$(=Max(Year))}>} Sales,'#,##0.0').

I think, getting error due to single quotations.

Could you please assist on this.

Thanks,

Nihhal.

[nihhalmca]

Thanks Miguel.

For second variable, it  would be

'Only({<Quarter={'&chr(36)&'(=min(Quarter,1))}>} QuartrandYear) &chr(13)&''(A)'''  - right?

[Miguel_Angel_Baeyens]

Looks about right, yes