i am not getting correct values. please help
are my formulas correct?
Hi @laxmitater ,
The formula you have written is absolutely correct. To debug this you can check the source module and system modules data once whether the data and mapping is correct or not.
Second, in the first view you can right click on the cell and drill down the formula and trace the source.
Hope it works.
Thanks,
Arnab
Hi, I'm using the OFFSET formula, where a calculated and number-formatted field determines how many previous weeks the formula should look back. Based on this value, it retrieves the corresponding week's data into the output line item. The formula works correctly for some products; however, it fails for others. The issue…
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.
