I have been for quite some time stuck on some error, which even after a few times reading through the documentation could not resolve. Below I have put pictures of the code. I would be really grateful, if you could explain and help me resolve the error.
As reference-set holds inverse references. For example, if Orders refer to Products, then you can specify a reference-set on Products that holds the inverse of those references: from Products to Orders, as expressed here.
In your code, you express that you want a reference-setAccomplished hours to hold the inverse of a reference 'Accomplished hours'. But your second piece of code expresses that Accomplished hours is a derived text value. It is not a reference (which are always specified with -> ... or ~> ...).
Some relevant parts of the code are missing in your sample, but if I understand correctly, what you want to express is:
'Company Information': group {
...
'Accomplished hours': number 'hours'
= sum ^ .'R&D hours overview'.'R&D hours details'* .'Number of hours worked'
}
Thank you for your response, I think I see where is the problem. However, I am trying to actually check whether the âTotal hoursâ are more or equal the âTotal planned hours to be accomplishedâ, but since it is not allowed to refer to âTotal hoursâ before defining it in âCompany informationâ, I was decided to try with downstream and reference, though I have maybe misunderstood their use cases. Could maybe tell me if there is a way to refer to âTotal hoursâ that are defined in below in another collection and compare them with âTotal planned hours to be accomplishedâ that are in the âCompany informationâ collection?