Hi all
I would like the down total of Pot Displacment in a seperate column. Which i tried in column dt(h) however it gives me a different result i want to -63.098. any idea what is wrong?
Thanks maik
Hi Maik, are you using a rule or anything like that? I'm just wondering whether it's to do with the execution order of the layout and it's getting the down total before it calculates something else? If you can post a screenshot of the layout itself it might shed some light
No nothing. In my opinion a straight forward calculation.
Ah okay, I think it's the use of the counter, I believe that the execution order with that and the algorithms is what's causing a problem. Although when I try to recreate something similar in 15 I only get a dt() value on the total row and not at all on the detail rows as soon as I involve Counter, works fine without using Counter.
Thanks Robert for the investigation. It indeed seem to be an issue with the counter. Whatever that does with the calculation.
The counter is a 'helper' for to easily show what is positive or negative. For some automated commentary i want to point to the total. Any thoughts how that can be achieved? replacing the counter with something else?
So am I understanding correctly that it's just the first 3 categories (95-100%, 90-95% and 80-90%) that should be negative or am I missing part of the logic? If it's just that those 3 categories are negative then I'd have thought you could just have a flag against those 3 categories to say that those require the negative calculation? I suspect I'm missing some extra complexity though :)
Do you mean an IF clause when x is equal to? that causes the same issue.
