Skip to Content
author's profile photo Former Member
Former Member

AST Member and Total in final year

Hi folks.

Please I have a dimension( A) and I want to display in total of year the last inputed value , because now if 31.12.2015 is empty 2015 is empty How could I achieve that?

thank you

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on May 24, 2016 at 04:26 PM

    You can't achieve it by design of BPC 😊

    AST - always YTD, and for YTD the Total is equal to the last base period of the year!

    As an alternative you can copy last loaded period to all empty periods till the end of the year.


    Add a comment
    10|10000 characters needed characters exceeded

    • Sorry, but I am completely lost with your explanations and the scripts you have! Also I have no idea how do you launch scripts.

      And the idea of the script from your last message is absolutely unclear...

      Sorry, may be it's better to open a new discussion and explain everything correctly, step by step?

      P.S. My original script was designed for:

      1. Single month data load of Balance Sheet accounts (AST,LEQ), data load has to be done in the order of months (01, 02,03....)

      2. After loading data to the last month the values of BS accounts will be copied to the remaining months of the year

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.