Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sum/Ratio problem

I have location I am trying to set a min and max up for a shipping schedule.  If filtered for a single day, everything looks fine but when include multiple days (like 5 days as shown in table below),...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Actual Total is a distinct count of shipment numbers

 

Incorrect 5 day Min Inbound is from a Lookup Value from a static table  that will be updated monthly

Cmcmahan's avatar
Cmcmahan
Resident Rockstar
6 years ago

So then wouldn't the fix be updating your static table with the correct values?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I don't believe so because it will change depending on how it is filter; day, week, month. 

     

    It is setup in the static table to be daily. 

     

    I believe I need to create a measure to avoid the calculated column, row by row taking the lookup value found in the static table and multipling by number of loads. 

     

    For example: I want it to calculate 5 days times 4 loads minimum a day for total of 20 loads in a 5 day period but it is taking 4 load minimum per day and multiplying by 9 loads(since 9 loads actually shipped over the 5 day period).