kim_barragan0126 Member

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!

It shows Date in my data, but string when I run it through ETL. I tried using a Alter tile and change to Date, but that causes an error. I also tried changing the file itself to text and date and both issues. Maybe I need support ticket?

I have five date fields so I am not sure the one that has the issue. All the dates are noted as the below. Is there a way to determine which field is causing the issue?

I am all good - thank you for asking!

Thank you. Good point. I also need a way to count how many candidates or matches, and that is why i was using the Distinct Count. Appreciate your help!

Yes. I will try it again. I appreciate the help!

The COUNT DISTINCT is not removing the duplicates. And if I remove dupes in ETL, i am losing the $ associated to the match ID's. The match ID's show up weekly, and I just want to count then once each week. Maybe I am not able to do so.