Challenge #495: Accounting Haunted House

[Shelbey]

Took on the bonus challenge... will forever be haunted by my 7x cartesian join, but it works 👻🏚

Spoiler

[mouna_belaid]

Spoiler

[jrlindem]

A fun and festive challenge.  Just tackling the main task for now.

Good skills to know being used in this exercise.  Gap-filling missing values while avoiding the skewing of results is common in financial-based reporting where data can be incomplete.  I rather enjoyed leveraging the median-based technique to negate missing values.

Here's my solution:

Spoiler

[alineruizcampos]

Couldn't download the optimization tool so worked around it with embedded iterative macros! Certainly overcomplicating things but it works! 👻

Spoiler

[AncientPandaman]

i went to deep for optimization....

Spoiler

i optimise the replace null by get the median and count null in summarise

just add [count_null]*[median] to the total.

bonus

Spoiler

using my own macro for combination. wonder why is not work for optional input in version 2023.2

[Yoshiro_Fujimori]

My solution.

Spoiler

Workflow

Bonus Task

I could not match the result exactly with the expected output.
Expected Equal Tool
Field [Set] --- I could not figure out what it means.
Field [Concat_Trigger Description] and [Proprosal] --- It looks OK, but Expect Equal Tool did not match.

As the Optimization tool works, I take this as "done".

[RebekaMazuchova]

:)

[Imaizumi]

Here is my solution and bonus.

Bonus is without macro and optimization tool if those are not possible to use. Also made sure that appending the data did not make the cache files close to Gigabytes.

Solution

Spoiler

Bonus

First calculate the maximum possible records

Second append only recordsID together

Blend to filter only maximum possible records and then merge the information to find the solution

Spoiler

[jackhunter2905]

Could'nt do the bonus

[AainaAggarwal17]

Spoiler