Set analyis question.

[#1]

Hello,

               I have the following formula (Expression) in pivot table:

                  sum({<ISGroup3={'Total Indirects'}, PeriodType3 ={'Current'}, Period4={$(=Only(Period3))}, ISOrg3 = { 'SKW-ID-FS' } >} ISAmount3)

          Essentially I am summing the information from another table which has no links to anything.  The above works just fine, however when I do the following I get the sum of zero.  NOTE: The section I am interested in is the ISOrg3 which changes by row.

               sum({<ISGroup3={'Total Indirects'}, PeriodType3 ={'Current'}, Period4={$(=Only(Period3))}, ISOrg3 = { $(=RTaskOrg) } >} ISAmount3)

     The value of RTaskOrg is another expression contained within the pivot table.  I have tried the following but no results:

          sum({<ISGroup3={'Total Indirects'}, PeriodType3 ={'Current'}, Period4={$(=Only(Period3))}, ISOrg3 = { $(=MaxString(RTaskOrg)) } >} ISAmount3)

          sum({<ISGroup3={'Total Indirects'}, PeriodType3 ={'Current'}, Period4={$(=Only(Period3))}, ISOrg3 = { $(=Column(7)) } >} ISAmount3)

    Any ideas?

Thanks,

[#2 · Accepted solution]

Does adding quotes around your $() help?

sum({<ISGroup3={'Total Indirects'}, PeriodType3 ={'Current'}, Period4={"$(=Only(Period3))"}, ISOrg3 = { "$(=RTaskOrg)" } >} ISAmount3)

[#3]

C,

That works! Thanks.