I've noticed an issue with the Round function while going through my L2 again. None of the available parameters seem to make it possible to get an accurate whole number rounded up.
In this example, I want the total (237.9) to be 238, not 240.
NVM. Was just a summary setting issue π
Hi @jzink1211 ,
It's not an issue actually. The round function appears working fine at week level, as you can see 60 for 59.47. It's the TIME SUMMARY setting that's making a sum of week level values (Four 60s) and giving us 240 at month level. For your expectation of 238, you should be setting the time summary to FORMULA.
Glad you figured that out.
Cheers!
Hi, I was hoping to get some help with this situation, where I am trying to take a list to list mapping on the left and get an output similar to the right, but the main idea is i want to be able to make the selected item (format: list), the dimension of a target module and reverse map the original source list as a listβ¦
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New β New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, noβ¦
Why in my model output is blank, after send explainability data.
