Jonas Beuschau Gudsø
Activity overview
Latest activity by Jonas Beuschau Gudsø-
Jonas Beuschau Gudsø commented, Hi Ole, That requires we work around with a hidden user dimension for that specific calculation, I suppose? Regards, Jonas
-
Jonas Beuschau Gudsø created a post, Absolute reference to hidden row in special calculations
My calculation sum(0, @"[P&L].[Resultat før skat].[10400: Turnover service items]"(l(3)), m1) does not work when my hierarchy is collapsed. Is it possible to modify the fomula to find the value whe...
-
Jonas Beuschau Gudsø commented, Hi Ole, Can you use the following screenshot? There is no hidden values in it. Best regards, Jonas
-
Jonas Beuschau Gudsø commented, Hi Ole, I understand it is a complex formula to create. Unfortunately, I cannot get access to the definition mode crosstab. It gives me an error. Is it possible to tell anything by the use of t...
-
Jonas Beuschau Gudsø commented, Hi Ole I have tried your solution, but it does not solve the issue. At the lowest level, the figures are correct, but I need the Grand sum to be equal to the sum of "Toyo oms mellemregn." from low...
-
Jonas Beuschau Gudsø commented, Hi Ole, The grand total is standard and the total oms calculation is as you describe. The problem is that in my simulation, I have increased the Total oms of rows less than 250.000 to 250.000 as mi...
-
Jonas Beuschau Gudsø created a post, Total sum of simulated values
I have a report where I have to make a simulation of current values. This is a calculated column based on an if formula of another column, stating that if less than 250.000, then 250.000 else just ...