Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Does anybody know? 😕
Here is the code I wrote:
508,615 * count(Period)
And it doesn't work. Why?
Would you be able to show a sample where we can see the issue?