Using the Round function in Rules

[tkingcka]

I am having an issue where one of my rules is rounding the value, where the other rule which has a feeder is not. How can I fix the value so they are both rounding the values and the total are the same?

[qml]

Request for assistance guidelines (PLEASE READ)

Any chance we could see your rules and feeders copy-pasted here (verbatim)?

[tkingcka]

As you can see the final total do not match between the allocation and GL Cubes. One value is 828 and the others are 824. I believe there is a rounding error, as well as an error on how the data is being fed, as the monthly values should each be different by Org. As you can see this is not the case. I am trying to assist someone with this issue and I too am struggling. Thank you kindly for your assistance.

[tomok]

Just how exactly are the screen shots you posted going to help anyone assist you? Where are the calculation rules?, Where are the feeders? What do the cubes look like? Why do you think they should be the same? What have you done to solve this yourself? Are we supposed to rub our fingers over the pictures and divine an answer without knowing any of the details?

[tkingcka]

As I said previously I don't normally use the forum for support, but for this instance I am and apologize for missing some of the rules for assistance. I am providing the rule and feeder for this calculation in the attached file. The Pool 29 Total for FY 14 is derived from the GL cube rule, while the 120-3-01 org is derived from the Allocations cube rule. The GL cube rule produced a value of 828, while the Allocation Cube rule provides a value of 824. If you look at all of the monthly values for each, they are exactly the same (Jul 14 = 64, Aug 14 = 64, Sep 14 = 79, ...). However, the GL rule seems to be using the whole numbers, while the Allocation rule is using the values as identified in the screen shot on page 2 of the 2nd post attached file (i.e. 63.6993). Therefore, in the end result, I see a difference of 4 between the two cubes. Pages 1 and 2 of my 2nd post attached file show the traces from the allocation cube, while pages 3 and 4 show the traces from the GL cube. In the end, you will see the Jul 14 number produced by both cubes is 63.6993.

My question is why is the GL cube final value when totaling all 12 periods equal 828 and the allocation cube total 824? Based on my review, I believe it to be a rounding error, as Pool 29 is one of the only pools with multiple organizations tallied together and creating a difference between the two cubes. All of the other pools tie in both cubes.

Again, Thank for your assistance.


Tomok...your comment was very rude and demeaning. I apologize for not providing the right amount of information, but there is a better way to ask for it without being so rude.

[BariAbdul]

"Tomok...your comment was very rude and demeaning. I apologize for not providing the right amount of information, but there is a better way to ask for it without being so rude."

Hi tkingcka,I think you took it a wrong way of Tomok's comment he just plain honest.Unless we provide complete information how else he would get the big picture.On the other hand we must appreciate the valuable time and wealth of knowledge shared by Tomok,Alan and all other gurus.I really do! Thanks

[qml]

Tomok...your comment was very rude and demeaning.

No, it really was not. Your original post igored the sensible guidelines of this forum that are meant to ensure that other people have sufficient information to provide help. And so I pointed you in the direction of these guidelines and also specifically asked to provide the code we absolutely need to help out. You ignored this request and in my opinion that should have caused everyone to just ignore this thread. Instead of doing that, tomok went out of his way to make sure you understand what it is that you need to give us and why. For that you should thank him, because the way I see it you stood no chance of having your problem solved whithout this intervention.

[tkingcka]

All, as I stated in my last post I apologize for not adhering to the rules when posting a question. I made a mistake and felt the comments Tomok made were accurate, but could have been said in a nicer way. Again I am sorry for not following the rules and believe I have provided all that is needed when asking a question to the users of the forum.

I have provided a 3rd document which may express what I was trying to say initially. I believe the rules and feeder for the GL cube values are correct, even as they are passed to the allocation cube. However, the rollup values for the allocation cube are not rounding the values up to equal the value I am looking for. I believe I have provided the screen shots and the rules that validate my comments. If I have missed anything, please let me know and I will do my best to provide them to you.

It has not been my attempt to frustrate anyone on the forum, just trying to get some help. Thank you in advance for your assistance and my sincere apologies for not following the guidelines.

[tkingcka]

...btw, I do respect the amount of time each of you provide to this forum, as this site has been a true asset to me , and probably many other TM1 users, over the years. Thank you for what you have done for the TM1 community through the work you have put in on the site.

[qml]

Can you please provide the complete code of your rules and feeders for both cubes? What you have put in the attachment would not even compile.

One immediate problem I can see is that your intercube rules are not fed. For example, the below rule:

[{'120-30-01', '120-30-02', 'DHO GA 21'}, {'Budget', 'Budget_v2', 'Actual'}, 'Pool Total'] = n:
DB('GeneralLedger', !Org, 'Pool 29', !Version, !Period, 'Amount');

It looks like it should have a coresponding feeder statement attached to the GL cube, which I can't see.

I think it would be way more productive if you focussed on helping us help you rather than on being offended and/or apologetic.

[tkingcka]

Thanks to everyone for the feedback. I was able to fix my rounding issue.