I have a jira issues which have some worklogs. I need to create a column where I multiply the hours by their hourly rate, which is different each year.
I’ve created calculated member formula, but I don’t see the price per hour for every listing
[Measures].[Hours spent]* (CASE when Year(TimestampToDate([Measures].[Worklog timestamp])) = 2021 then 420 when Year(TimestampToDate([Measures].[Worklog timestamp])) = 2022 then 440 END)
In this table I currently show the year 2022.
Unfortunately, I have no idea where the mistake is. It happens when I have multiple job reports for one problem.
Thank you for your help.