Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
why its not working -
sum({<BU_Year_Quarter={"=SubField(concat(distinct BU_Year_Quarter,'-',),'-',1)"}>}BudgetCurrentBook_UNIT)
?
Hi Adi
Try below expression
Sum({<BU_Year_Quarter ={"= SubField('$(=concat(distinct BU_Year_Quarter,'-',))','-',1)=BU_Year_Quarter"}>}BudgetCurrentBook_UNIT)
try
sum({<BU_Year_Quarter={"=$(=SubField......)">}BudgetCurrentV´Book_UNIT)
Hi adi,
explain little briefly for my understanding.
hi,
i want the sum of-BudgetCurrentBook_UNIT
when
BU_Year_Quarter = SubField(concat(distinct BU_Year_Quarter,'-',),'-',1)
tnx,
but its not working
its giving me -sum(BudgetCurrentV´Book_UNIT)
Hi Adi
Try below expression
Sum({<BU_Year_Quarter ={"= SubField('$(=concat(distinct BU_Year_Quarter,'-',))','-',1)=BU_Year_Quarter"}>}BudgetCurrentBook_UNIT)
can you test in a TextBox if the Expression subfield(..... is correct?
tnx!!!!