Hi all,
I have a use case to create a salary benchmark report in our Creatio recruitment application, which shows what salary expectations our candidates had in a set period, structured with
I store the salary expectation min. and max. on the Candidate's record, and I have an object called "Candidate's related fields", which consists of the main field (e.g. Software development), sub-field (e.g. .Net developer), and level of expertise (e.g. senior). One Candidate can have multiple related fields, and his/her salary expectation should be taken into account in all of them.
I was thinking about using the Forecast section to create a report that looks like the example in the following picture. I successfully created the frame (the "Candidate's related fields" being the Forecast object, the "Main field", "Sub-field", and "Level of expertise" being the 1-3 hierarchy levels.
I have issues with setting up the columns; it seems to me that the Forecast functions are not sufficient to fulfill what I want to achieve.
The main issue is, that the values are aggregated as I go upwards on the hierarchy levels, so the "Junior .Net software developer" row will have a sum of every individual row.
My question is, does anyone have any insight on whether this requirement can be met with Forecast? We have a few ideas about using auxiliary tables and business processes instead, but it would be great if it could be done very simply with Forecast.
Thanks in advance!
Like