Variable using quotes (") is not working when loaded

[zagzebski]

I am trying to get the variable to load correctly but I am having issues with quotes. I tried to use chr(34) but no success. chr(39) worked fine for apostrophes but can't figure out how to write variable so set expressions work for quotes.

VARIABLE:

vClaimsPYImpSiteMetroNoOther = '(sum({$ <
      [MI Imp Site Metro Regional DVC] = {"*"}-{'&Chr(39) & 'Other' &Ch(39) & '},
      [Incurred Year Month] = {"<=$(=Max([Incurred Year Month]-100))"},
      [Incurred Year] = {"$(=Max([Incurred Year]-1))"},
      [Paid YearMonth] = {"<=$(=Max([Paid YearMonth]-101))"}
>} [Claim Amt Allowed]))';

RESULT:

sum({$ <
  [MI Imp Site Metro Regional DVC] = {"*"}-{'Other'}
  [Incurred Year Month] = {"<="},
  [Incurred Year] = {""},
  [Paid YearMonth] = {"<="}
>} [Claim Amt Allowed]))

Thanks in advance,

Zag

[lironbaram]

hi

not really clear what you want to achieve

what is the expected result you are after ?

[zagzebski]

Liron -

basically this part of the variable needs to stay the same...

[Incurred Year Month] = {"<=$(=Max([Incurred Year Month]-100))"},

[Incurred Year] = {"$(=Max([Incurred Year]-1))"},

  [Paid YearMonth] = {"<=$(=Max([Paid YearMonth]-101))"}

but when loaded looks like this...

[Incurred Year Month] = {"<="},

  [Incurred Year] = {""},

  [Paid YearMonth] = {"<="}

[maxgro · Accepted solution]

let vClaimsPYImpSiteMetroNoOther =

  'sum({$ <

       [MI Imp Site Metro Regional DVC] = {"*"}-{Other},

       [Incurred Year Month] = {"<=' & chr(36) & '(=Max([Incurred Year Month]-100))"},

       [Incurred Year] = {"' & chr(36) & '(=Max([Incurred Year]-1))"},

       [Paid YearMonth] = {"<=' & chr(36) & '(=Max([Paid YearMonth]-101))"}

  >} [Claim Amt Allowed])';

result is (ctrl+alt+V)

sum({$ <

       [MI Imp Site Metro Regional DVC] = {"*"}-{Other},

       [Incurred Year Month] = {"<=$(=Max([Incurred Year Month]-100))"},

       [Incurred Year] = {"$(=Max([Incurred Year]-1))"},

       [Paid YearMonth] = {"<=$(=Max([Paid YearMonth]-101))"}

  >} [Claim Amt Allowed])

[zagzebski]

THanks! Although not sure why it worked. chr(36) is for the "$" sign. Why does that make it work?

Again - much apppreciated,

Zag

[zagzebski]

dumb question - I understand now.

Thanks.