Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

CLOSINGBALANCEYEAR

Hi all,   I'm trying to create a modification to something like the CLOSINGBALANCEYEAR function.   I need to see the total value of a budget between 2 periods. Seems fairly easy but the issue i'm...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous 

In the two screenshot, "Budget for selected period" is the grand total between dates 2 to 7 (example only) if the user selected it, It is your expected result, right?

In the "Budget" column, values only exsits in the first day of each month, it means for each whole month instead of one day, right?

For example, for month1, it has a budget 100, for month2, it has a budget 150.

 

Best Regards

Maggie

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    It’s right it is a budget by period and each budget is by a single day only to represent the entire month.

    The issue is I need to show the full budget for all selected period at each month, so the full budget as at Jan is equal to the total budget across months -, 2 & 3