Hi everyone,
My values don't seem to be very realistic, would just like to ask for guidance if I'm doing something wrong. Or if someone could check the values.
@mkrystle Hi
You should definitely get rid of negative values in inventory as it cannot be negative. Also, I think you are missing inventory income in your formula. Probably there is some production or purchase to be added in the first equation.
Hi @mkrystle Try changing your summary to formula for calculating percentage.
Any update on this? I'm in the same boat not sure what to make of the negative percentage full values
Hi @kmurphygs , what are you facing?, can you send pictures? and is it part of Level 2 learnings? which sprint?
Hi @sobaid here are some images and comments; I am at the same stage. Are the formulas and negative values correct? As previously mentioned, someone said to eliminate the negative numbers.
1. You can see the negative values in the first image below.
2. Here are the formulas and Summary
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
I have a question about the new Expand or collapse grid rows option. Is it possible to publish a grid containing a 5-level hierarchy so that all items from levels 1 and 2 are always visible? And I do not want to use a filter for this.
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…