on 2024 Sep 09 12:44 AM
Hi Experts
I have a calculation that is not working and hoping you can help. I have a data action that looks at the Trial balance (has income statement and balance sheet data). I need to round the amounts/values to the nearest thousand. And then post the rounding difference [(Amounts/1000) - Round((Amounts/1000),0), to 3 accounts.
The issue is that the rounding difference I see when I run the data action, I get a higher number than expected. Please advise, thanks in advance.
My Data action:
MEMBERSET [d/CBS_PROFIT_CENTER] = (BASEMEMBER([d/CBS_PROFIT_CENTER].[h/TOTAL], %profit_center%))
IF [d/Measures] = "IS_Rounding" AND [d/CBS_ACCOUNTS] = "ROUNDING_IS" AND [d/CBS_Account_Cognos].[p/BIS_Company_Code] = "46212" THEN
DATA([d/CBS_ACCOUNTS] = "ROUNDING_IS", [d/Measures] = "Rounding_Measure", [d/CBS_Account_Cognos] = "IS-ROUNDING46212M-PL20300") = RESULTLOOKUP([d/CBS_ACCOUNTS] = "ROUNDING_IS", [d/Measures] = "IS_Rounding")
ENDIF
IF RESULTLOOKUP([d/Measures] = "IS_Rounding", [d/CBS_ACCOUNTS] = "ROUNDING_BS") < 0 THEN
IF [d/CBS_Account_Cognos].[p/BIS_Company_Code] = "46212" THEN
DATA([d/CBS_ACCOUNTS] = "ROUNDING_BS", [d/Measures] = "Rounding_Measure", [d/CBS_Account_Cognos] = "BS-ROUNDING46212M-BS20400") = RESULTLOOKUP([d/CBS_ACCOUNTS] = "ROUNDING_IS", [d/Measures] = "IS_Rounding")
ELSE
DATA([d/CBS_ACCOUNTS] = "ROUNDING_BS", [d/Measures] = "Rounding_Measure", [d/CBS_Account_Cognos] = "BS-ROUNDING46212M-BS10420") = RESULTLOOKUP([d/CBS_ACCOUNTS] = "ROUNDING_IS", [d/Measures] = "IS_Rounding")
ENDIF
ENDIF
User | Count |
---|---|
71 | |
11 | |
10 | |
10 | |
10 | |
8 | |
7 | |
7 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.