Forum Discussion
Helper ITotal error when Retrieve the last available value from a table.
Helper Iis use "Enter data" option for every table in the file to allow any one with the file see the data
- 1. "balance carrying amount" / last value per GL account?
**Not the carrying amount only the last value available of a GL.
- 2. amounts should be combined meaning if you select 2023 and February per visual it should be shown not only 2023 and Februar but other last amount?
**Yes
- some_bih
Community Champion
Hi Ezzeldin
Check enclosed file. I created two measures as below.
I check for two GL ID's as shown on picture below
Sum_simple sum =--simple sum formulaSUM(BRU_Facility_Limit[Facility_Limit])Sum adjusted =IF (ISEMPTY ( BRU_Facility_Limit ),CALCULATE ( [Sum_simple sum], OFFSET ( -1,, ORDERBY ( 'DATES'[Date] ), ) ),[Sum_simple sum]) - Ezzeldin
if gives me an error.
- Ezzeldin
Unfortunately, the result is still incorrect.
- Ezzeldin
hi some_bih ,
Based on the screenshot provided, I tested GL 102122. When I selected Year 2023 and Month 1 for Company Code 1000, the expected result was 200,000,000. Similarly, for Company Code 2000, the expected result was 300,000,000. The total amount was expected to be 500,000,000.
- Ezzeldin
200,000,000 is the last available value for GL: 102122 in company code: 1000 when we choose Year: 2023 and Month: 1.
if we choose Year: 2022 and Month: 2 the last available value for GL: 102122 in company code: 1000 is:165,000,000same for company code: 2000 when we choose Year: 2023 and Month: 1 the result for GL: 102122 should be: 300,000,000 which is the last available value before the last date of the selected month as my measure dose.
the problem with my measure is with the totals.