0

enter image description hereI've been trying to display return on marketing investment ROMI for the CURRENT SELECTED WEEK (CW) in my table. I'm using a parameter that displays data by week number - all other calculated fields that I created in the same way worked.

Unfortunately I can't seem to find a solution on why the calculated field displays always the wrong number when selecting the week in my parameter. It seems to add up all available values from every day, not just the selected week from the parameter.

Any help or hints are greatly appreciated.

Improve this question
4
  • how many years of data are stored in your datasource? using week as datepart, you may have the risk of getting the aggregated value for that week34 in multiple years
    – Fabio Fantoni
    Commented Sep 6, 2024 at 10:30
  • Not much at all. Only like 6 months worth of data. I'm starting to think my source table might be the issue since I already aggregated the data for financials by day while in my other source table I still have multiple entries per day. However there still should be a way to display each week aggregated, but I haven't found one yet.
    – Paul
    Commented Sep 6, 2024 at 11:57
  • actually your formula seems correct and I've double checked with a generic superstore. could you maybe add some more detail about the datasoucre? maybe a snippet of it?
    – Fabio Fantoni
    Commented Sep 6, 2024 at 14:21
  • can you add a screenshot of how your [SELECT WEEK] parameter is configured?
    – MUFF.
    Commented Sep 6, 2024 at 19:36
Related questions
2685
Set a default parameter value for a JavaScript function
1107
What's the difference between an argument and a parameter?
1036
How can I pass a parameter to a setTimeout() callback?
Load 5 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.