List Box Help Needed

Ankhi — Mon, 08 Mar 2021 14:30:35 GMT

Hi All,

I need a help on creating a list box on a Measure value.

I have the below table. There are many other measures and dimensions. For sample I have just given 3.

Project Number Project Type Available Budgets

1234 T 6000

4321 T -5000

The available budget measure is a expression shown below. I would like to have a list box which will have values like

'Overbudget Projects' and on selecting that value will only show me the projects that are in overbudgets range . In this case 4321 with -5000

I was trying with something like this . The variable contains the same Available Budget Expression. but it is not working.

=IF($(VOverBudget) < 0 ,'Over Budget Projects',null())

Available Budget Expression

Sum ({$<
Type = {'Budget'},
Month =,
FY Year =,
[Budget Type] = {'CBT'},
[Budget End Date] = {"<=$(=(YearEnd(AddMonths(today(),24))))"}
>}
Amount)

Sum ({$<
Type = {'Act'},
Month =,
FY Year =
>}
Amount)

Thanks in advance.

Regards

Ankhi

Re: List Box Help Needed

rwunderlich — Mon, 08 Mar 2021 18:29:04 GMT

=Aggr( IF($(VOverBudget) < 0 ,'Over Budget Projects',null()), [Project Number])

-Rob

Ankhi — Tue, 09 Mar 2021 14:26:50 GMT

Thanks a lot @rwunderlich . It worked.