Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using the following expression
sum({<[Budget Month] = {'$(= GetFieldSelections([Forecast Month]))'}>}Budget)
It only works if I select one value from Forecast month. If I select multiple months from foreclast month, the value is zero. I want that if no forecast month is selected, take sum of all budget months, otherwise take the sum of budget for those budget months for which I select the forecast months from listbox
Forecast month and budget months are two different month fields.
Arif
Try to create this variable:
vForecastMonths
=replace(chr(39)&concat([Forecast Month],',')&chr(39),',',chr(39)&','&chr(39))
and change to this the expression:
sum({<[Budget Month] = {$(vForecastMonths)}>}Budget)
Hope this helps
Try:
=Sum({<[Budget Month]={$(=Concat(Distinct chr(39)&[Forecast Month]&chr(39),','))}> }Budget)
Try this
sum({<[Budget Month]={$(=GetFieldSelections([Forecast Month],',',100))}>}Budget)
100 should be atleast the number of distinct values in Forecast Month
Cheers,
Naresh
Hi
Have you tried: sum({<[Budget Month] = P([Forecast Month])>} Budget)
HTH
Jonathan