Forum Discussion

azizshaikh's avatar
azizshaikh
Frequent Visitor
10 years ago

Opening Balance row wise

Hello All,   I need a help in my data where i wanted to get the Opening balance of each customer row wise and its being controlled by a report level date filter. eg. If my report level date filter...
azizshaikh's avatar
azizshaikh
Frequent Visitor
10 years ago

Hello,

I had tried OPENINGBALANCEYEAR in measure but it came up with a blank value.

Let me share an example:

 

Name     Opening Balance     Column1     Column2     Closing Balance

1st person        2500                           100              50                2650

2nd person       1500                           150            100                1750

 

In above example each person will have its own opening balance based on the dates which will be passed by the report level filter, so if am setting a report filter from 01/01/2016 to 25/04/2016 then the opening balance should show up till the 31/12/2015 for "1st person" and "2nd person" respectively.

 

I had tried with some of the Time Intelligence functions but couldn't get desired result, as it mostly gives me Circular Dependency error.

 

Thanks

  • achinm45's avatar
    achinm45
    Advocate IV
    10 years ago

    Hi azizshaikh

    Can you send me the screenshot of your measure or calculation ?

    I will need to know how are you putting filters dates. Is that single column or two columns ?

     

    BR,
    Achin