Data Shuffle Errors

I have a daily data shuttle that brings in data from a Pivot Table via Excel. I have attached a screen snip of my filters. It does not bring over any credit values (Example: -$200.00) and I need it to for accurate reporting. Please advise on how to correct my filters so all applicable data shuffles in.


Answers

  • MichaelTCA
    MichaelTCA ✭✭✭✭✭✭

    Hello @Calderon93

    From what you have shown, the only recommendation I can think of is removing the filters entirely.

    Otherwise you can try adding another value to specify whether the amount is credit, in the source file. Then add that as a new filter. Although that would be counterintuitive because you're already filtering out everything that's on credit by requiring the value to be greater than 0.

  • I will try that. Thank you for the assistance!