So easy! Thank you!!!!!!

Does this help? For the company name, I have selected one company, and the Match Status is Full Placement. The other filter is removing any matches that have ended already. I have removed the names for confidentiality.

That doesn't work either. I also tried the below. And I made sure my Date columns were not strings. Maybe I need to go to support? DATEDIFF(Current Date,StartDate,'DD')

Thank you. I have not heard of this before, so I will see if I can figure it out. I am not sure why the format would change as the report is always the same - thanks!

I just tried it and it works great - thank you!

I want show a trend such as the below. Could I do this from the beast mode you suggest?

Thank you. Can you clarify what you mean by the summary number?

Thank you!

The issue is I had to use a join in ETL of add a forecast, which I am calling Direct Hire GP. And the $363,269 populated on each line, so I just to show the $363,269 one time.

Thank you for the comments. Below are my columns. I am assuming the issue is that my first column is a Sum/distinct. Is there a way I can get an accurate total? First Column Third Column

Thank you, both!

I figured it out - thanks!

I am getting a Syntax Error when I use in Beast Mode.

Thanks! Do you how I can fix the below. Appreciate the quick replies! Second issue is the 27,504.75 minus -77,584.85 should equal -50,080.10, but it is showing 105,089.60. Is there a better Beast Mode Formula I can use?

Is this in ETL or Beast Mode? Thank you!

I am up and running now.

Thanks. They must have just updated the site with the stats. Thanks, again.

I appreciate all the help!

Thank you. That did work, but I have lost some of the other columns, such as the start date, timesheet batch etc. Is there another way, or possibly a beast mode to keep the other columns? I especially the start date. If not, no worries, and thank you! Happy New Year!

Thank you! I was going down the wrong path trying to use Group By or Dynamic Pivot. Thank you!

Perfect! Thank you. I also used it to omit End Dates in the past. I appreciate the learning! CASE WHEN ActualEndDate< NOW() THEN 1 ELSE 0 END

Thank you! But I am getting an error.

thank you!

Thank you! The command worked great.

Thanks for your help. I am good now!

I believe that filter there because I am adding the PDP to see what the user will see.

Thank you. I am going to play around with it this afternoon, but will let you know if I need further help. What is strange is the card is correct, but if I enlarge the card, the number changes and the PDP seems to not work.

thank you!

Thank you all! I have fixed the issue, not sure how I fixed it, but it is good now. I will go back now and see what steps worked. I appreciate all the help as it did help me determine what the issue was, and how to research it. Thank you!