Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=Aggr( IF($(VOverBudget) < 0 ,'Over Budget Projects',null()), [Project Number])
-Rob
=Aggr( IF($(VOverBudget) < 0 ,'Over Budget Projects',null()), [Project Number])
-Rob
Thanks a lot @rwunderlich . It worked.