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

WaiWah
WaiWah
in Academy Discussions

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

or

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 ?

Answers

  • devrathahuja
    devrathahuja

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

  • WaiWah
    WaiWah

    This is my source dimension.

    image.png

    This is my target dimension.

    image.png

    Thank you for your attention.

  • SriNitya
    SriNitya

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

  • devrathahuja
    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
    SriNitya

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

  • WaiWah
    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
    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
    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
    Prajjwal88
    edited March 21

    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
    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.

Categories