hello.
please look at the Image. How to formula the column by part1 and part2? thanks!
Hello psky,
[quote users="psky"] But the formula can't explain the multiple nested function. It is a pity![\quote] Please note that it is a custom function and I made this function only for one level of grouping. Using the same approach you could create function which supply two, three or more level of grouping
[quote users="psky"]The following summation, also can solve through the custom formula?[\quote] Yes, you could create your own function.
Regards
The custom of a column, I do. But the formula can't explain the multiple nested function. It is a pity! And thank you very much for your patience. The following summation, also can solve through the custom formula?
If you need any additional assistance don’t hesitate to ask.
If I understand well your final goals, we could skip "Part12" column from your DataSource. But we need to have a column for our GroupBy, so my suggestion is:
1. To skip "Part 12" column from DataSource
2. We will add new unbound column with the same name - "Part 12". Also this column will be hidden
3. We will apply Concatenate function to this Unbound column.
Please take a look at the modifications that I made into our sample and let me know if you have any questions.
Only you understand me, thank you for your hard work.
I found a new problem. Instance, if I according to field Part1 and part2, then the formula5 and. Formula does not recognize the complex formula.
Could I trouble you to look at how to modify it. The new formula is as follows: