Set expression for dividing a number with a row of data in a dataset
Hi,
I think it's better that I describe the problem I have rather than laying out my attempts to code it. Here goes:
I am creating an app that compares the budgeted hours with the self-reported hours for employees at a company. The user should be able to pick any weeks from a list of weeks in a pivot table and see a KPI of the total amount of budgeted hours for the chosen weeks. Each week should have 1/52 of the value of the total hours for the entire year chosen.
If I don't want to add a new field in my dataset with the 1/52 number connected to the relevant fields, how do I go about writing a Set expression to make Sense calculate the correct number in the KPI box?
