Forum Discussion

AlainB's avatar
AlainB
Frequent Visitor
7 years ago
Solved

Future Account Balance Development with Fix Cost Budget Table

Hi,   I am a little bit stuck at moment.   I would like to create a Dashboard with show the future development of an Accouts Balance based on a Budget table. Here the tables I have.   dCalen...
  • AlainB's avatar
    AlainB
    7 years ago

    Hi There,

    Found a way myself:

     

    fBudgetForcast = 
GENERATE(dCalendar; 
    CALCULATETABLE(dBudgetFixCosts;
        FILTER(dBudgetFixCosts;
            dCalendar[DayNo] = dBudgetFixCosts[RenewDayNo]);
        FILTER(dBudgetFixCosts;
            OR(
                dBudgetFixCosts[Periodicity] = "Monthly";
                AND(dBudgetFixCosts[Periodicity] = "Yearly";
                    dCalendar[MonthNo] = dBudgetFixCosts[RenewMonthNo])
            )
        )
    )
)

    The Main issue for was to find the correct logic. Maybe there is a nicer way...but for the moment it works.

    If anyone has a better idea how to sovle my problem, thanks in advance.

     

    Regards,

     

    Alain

AlainB's avatar
AlainB
Frequent Visitor
7 years ago

Hi There,

Found a way myself:

 

fBudgetForcast = 
GENERATE(dCalendar; 
    CALCULATETABLE(dBudgetFixCosts;
        FILTER(dBudgetFixCosts;
            dCalendar[DayNo] = dBudgetFixCosts[RenewDayNo]);
        FILTER(dBudgetFixCosts;
            OR(
                dBudgetFixCosts[Periodicity] = "Monthly";
                AND(dBudgetFixCosts[Periodicity] = "Yearly";
                    dCalendar[MonthNo] = dBudgetFixCosts[RenewMonthNo])
            )
        )
    )
)

The Main issue for was to find the correct logic. Maybe there is a nicer way...but for the moment it works.

If anyone has a better idea how to sovle my problem, thanks in advance.

 

Regards,

 

Alain