This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Length sum

Hello, How can I make a formula in a custom user field that adds the length of the element based on the parameter named "lenght" or a created parameter called "ACC_MG_Largo", that is, a parameter with another name. The elements can have one or the other parameter. So far I have something like that, but it doesn't work for me.
First parameter sum: SUM(RESOURCE.UFV("Family Parameter: ACC_MG_Largo")) 
Second parameter sum: SUM(RESOURCE.UFV("Length")) 
first and second parameters in the same formula would be something like this?    :   SUM(RESOURCE.UFV("Family Parameter: ACC_MG_Largo"))   OR    SUM(RESOURCE.UFV("Length")) 

Thanks

Parents
  • Hi - Before I can provide any help, there are two questions:

    #1 Are you trying to get the sum for a Task UF from all its associated resource UFVs? 

    #2 For each task, does its resources have either "Family Parameter: ACC_MG_Largo" or "Length"? Or it can have both UFs?

    In this case, would it be easier to create an additional Resource UF to get values from either "Length" or "Family Parameter: ACC_MG_Largo" so all length values are in the same Resource UF? 

    Then you can do a sum for the Task UF. 

    Also - providing an SP file would be a lot easier for anyone who wants to help you so they don't need to recreate the file. 

Reply
  • Hi - Before I can provide any help, there are two questions:

    #1 Are you trying to get the sum for a Task UF from all its associated resource UFVs? 

    #2 For each task, does its resources have either "Family Parameter: ACC_MG_Largo" or "Length"? Or it can have both UFs?

    In this case, would it be easier to create an additional Resource UF to get values from either "Length" or "Family Parameter: ACC_MG_Largo" so all length values are in the same Resource UF? 

    Then you can do a sum for the Task UF. 

    Also - providing an SP file would be a lot easier for anyone who wants to help you so they don't need to recreate the file. 

Children
No Data