set analisys problem

[adiarnon]

why its not working -

sum({<BU_Year_Quarter={"=SubField(concat(distinct BU_Year_Quarter,'-',),'-',1)"}>}BudgetCurrentBook_UNIT)

?

[Anonymous]

try

sum({<BU_Year_Quarter={"=$(=SubField......)">}BudgetCurrentV´Book_UNIT)

[perumal_41]

Hi adi,

explain little briefly  for my understanding.

[adiarnon]

hi,

i want the sum of-BudgetCurrentBook_UNIT

when

BU_Year_Quarter = SubField(concat(distinct BU_Year_Quarter,'-',),'-',1)

[adiarnon]

tnx,

but its not working

its giving me -sum(BudgetCurrentV´Book_UNIT)

[perumal_41 · Accepted solution]

Hi Adi

Try below  expression

Sum({<BU_Year_Quarter ={"= SubField('$(=concat(distinct BU_Year_Quarter,'-',))','-',1)=BU_Year_Quarter"}>}BudgetCurrentBook_UNIT)

[Anonymous]

can you test in a TextBox if the Expression subfield(..... is correct?

[adiarnon]

tnx!!!!