Jonas Beuschau Gudsø

1. Community
2. User Tips and Tricks
3. Absolute reference to hidden row in special calculations

Hi Ole, That requires we work around with a hidden user dimension for that specific calculation, I suppose? Regards, Jonas

• View comment
• Created September 01, 2025 10:33
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Total sum of simulated values

Hi Ole, Can you use the following screenshot? There is no hidden values in it. Best regards, Jonas

• View comment
• Created March 24, 2023 11:58
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Total sum of simulated values

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...

• View comment
• Created March 16, 2023 13:47
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Total sum of simulated values

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...

• View comment
• Created March 13, 2023 14:17
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Total sum of simulated values

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...

• View comment
• Created January 31, 2023 15:54
• 0 votes