Module line item formula = another module line item value. But failed

WaiWah

When I use the following as formula of a line item in order to assign the value of another module line item to it:

'CAL01 KISO Prelim Summary - v3'.Direct Fixed Cost

MONTHVALUE('CAL01 KISO Prelim Summary - v3'.Direct Fixed Cost)

It gave me a value equal to 52 times of that month's Direct Fixed Cost value. Is it something to do with 52 weeks ?

Would please enlighten me ?

Accepted answers

All comments

devrathahuja

@WaiWah - What are your source & target module dimensions?

WaiWah

This is my source dimension.

This is my target dimension.

Thank you for your attention.

SriNitya

What are Source and Target time dimension levels (i.e Months, weeks etc.,)

devrathahuja

@WaiWah - You have an extra dimension of GL account. Is there a mapping/If statement that you're using in your target?

Otherwise the same value will be replicated for all the GL accounts.

SriNitya

@WaiWah If the time dimension is same in both modules why are you using MONTHVALUE in logic

WaiWah

Hi, SriNitya

My Time dimensions are month level. So I don't need to add MonthValue, since both gave me the same answer.

My question is the 52 times of the correct answer. Which is wrong

Regards

Thank you.

WaiWah

Hi, Devrathahuja.

Good morning.

"You have an extra dimension of GL account. Is there a mapping/If statement that you're using in your target?"

Yes. In my target dimensions have GL account. Do you mean I need to add GL Account dimension to my source also?

Regards.

WaiWah

Hi, Devrathahuja.

I checked. Really, I have 52 GL Account code under that group. Do you have any suggestion that how I should change my formula or change the dimensions

Prajjwal88

Hi @WaiWah ,

Could you please share the blueprint view of the Target Module, I assume you're checking the value for respective line Items at Top level of GL Account Code List and hence if summary method is set to SUM it would be summing up the numbers to the number of list members present in list- GL Account Code.
Hence, the simplest resolution would be changing your summary method to "Average," but this would still distribute the same higher value to all GL Codes.

Alternatively, if you need to divide that number equally across all GL Codes, you can keep the summary method as "SUM" and adjust the formula to divide by the total count of GL Codes.

Hope this helps!

devrathahuja

@WaiWah - The value you're pulling should be going to which of the destination line items?

You could either set up a SYS GL account module & a boolean line item there to identify the GL so the formula can be IF boolean then value else 0

Or, set up the account mapping in a SYS Lookup module & the formula can be source[sum:mapping]

If you want your source to have a different value of each destination line item, then yes source should also have the GL dimension & then you can have your calcs in the destination module.

WaiWah

Thank you, Prajjwal88.

Thank you, devrathahuja

I have done it in Dividing by GL Code Count way for the time being. I may improve it later.

Once again, thank you and appreciated.

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…