![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
Need help with this again - and my problem is the same as the problem I had 6 months ago. Still don't get it. Created following sentence: iif([RammeDelValAktKonto].currentmember.name = "Statens indtægtsbudget",0,iif([RammeDelValAktKonto].currentmember.name = "Skoleudgifter",0,iif([RammeDelValAktKonto].currentmember.name = "UM's sygeforsikring",0,iif([RammeDelValAktKonto].currentmember.name = "Kursregulering",0,iif([RammeDelValAktKonto].currentmember.name = "Chefens medhjælp", iif([Measures].[Budgetafvigelse] < 0, [Measures].[Budgetafvigelse],0),iif([RammeDelValAktKonto].currentmember.name = "Eksportfremme, indtægtskrav", iif([Measures].[Budgetafvigelse] < 0, [Measures].[Budgetafvigelse],0),iif([RammeDelValAktKonto].currentmember.name = "Kulturformidl.", iif([Measures].[Budgetafvigelse] < 0, [Measures].[Budgetafvigelse],0),iif([RammeDelValAktKonto].currentmember.name = "Spec. Att.", iif([Measures].[Budgetafvigelse] < 0, [Measures].[Budgetafvigelse],0),[Measures].[Budgetafvigelse])))))))) ..But when displaying the all member disrecards the 0 setting of some of the members above ... it just sums the original amouns. |
![]() |
| Thread Tools | |
| Display Modes | |
| |