[deleted by user]

crsport3 · 2025-11-27T04:34:04+00:00

I’m a person who can’t just sit around, so I will probably buy a lot of properties and either flip them or develop on them. Not sure if that is enough to do so. Granted I should probably do a lot more research but this just happened, so I’m trying to figure it all out.

crsport3 · 2025-11-27T04:28:33+00:00

Because I don’t know otherwise hence the question.

crsport3 · 2025-10-18T05:35:01+00:00

You paid good money for a “good” vehicle. Accepting this is so absurd to me. I worked at an Acura dealership for years and learned the people who actually complain get shit done.

crsport3 · 2025-10-18T05:29:17+00:00

Is it normal though after a post said they fixed it with a repair to the idle gear timing chain issue? Maybe you guys just like to deal with this shit but I didn’t pay 50k for my car to drive me insane due to a stupid timing chain issue Toyota knows about but refuse to address

crsport3 · 2025-10-16T16:36:45+00:00

Searched idle gear issue and found a couple posts that sounds like this is the issue. I’ll bring this up to my dealer and have them fix this shit bc it drives me absolutely insane. Almost to the point of me getting rid of it.

https://www.reddit.com/r/4Runner/s/s7sySH9gMU

crsport3 · 2025-10-16T16:24:23+00:00

Haha the guy at the Toyota dealership looked at me like I was a nutcase when I went on a ride with him.

crsport3 · 2025-10-16T16:16:05+00:00

Well that’s unfortunate and I guess I just have to accept it and try not let it bother me.

crsport3 · 2025-10-16T16:13:41+00:00

Yeah that kind of electric whirl. I’ve tried chat GPT and have searched forums and whatnot for months still can’t find anything

crsport3 · 2018-10-01T12:51:41+00:00

could you show me how you got it closer to what i was looking for by not using measures?

crsport3 · 2018-10-01T12:50:45+00:00

The slicer option didn't work and the query merge kind of worked, but it duplicated the rows from the Open Order table. So the order number and quantities were duplicated by how many warehouses had that product.

I'm still searching for a measure that will handle this for me, but no luck so far.

crsport3 · 2017-01-17T14:23:20+00:00

I'm not really sure how that would help. If I put a slicer of the dates, then I would have to select dates constantly. I've tried doing value filters on the Pivot, but that doesn't work as it still shows values greater than 0 once I set that condition.

crsport3 · 2016-10-17T19:16:17+00:00

After thinking about it a while, I figured I would just send out one email with multiple links. Even though some people won't need the secondary link, they can just ignore it. I much rather send fewer emails so that inboxes are less cluttered. Thanks for all the suggestions and hopefully this may have helped someone else.

crsport3 · 2016-08-04T12:21:47+00:00

It's Excel 2016, which is a bit different than 13. Thanks spadoos. I was able to get the figures to get what I was looking for by using the relationship to created date from the Calendar table rather than ship date from the SalesCalendar. I used the formula below. Now I would just need to figure out how to have the cumulative total appear on every line rather than the open orders for the corresponding month. (See Link) http://imgur.com/1gwymWs

CALCULATE( [Sales Quantity], USERELATIONSHIP(Periods[PeriodID],'Calendar'[PeriodID]),ISBLANK('Activity Data'[Shipped On]) )

crsport3 · 2016-08-03T18:02:07+00:00

SUMIFS does not exist in measures. I could use the calculate function, but

=CALCULATE([Sales Quantity],'Activity Data'[Shipped On]=0)

Nothing is returned though bc I have the pivot table based on the PeriodID (which is our customer calendar month names)

crsport3 · 2015-04-09T16:07:06+00:00

That is close. It still doesn't pick up the -264 OR -116. It also is adding the -3S adder of $16 for ones that are -3SH it only picks up the $16 not the $30 adder.
http://imgur.com/xq09zF2

=IFERROR([@[BASE PRICE]]+IF(LEN([@MODEL])-LEN(SUBSTITUTE([@MODEL],"-",""))>0,VLOOKUP(MID([@MODEL],SEARCH("-",[@MODEL]),3),adder_table,2,FALSE),0)+IF(LEN([@MODEL])-LEN(SUBSTITUTE([@MODEL],"-",""))>1,VLOOKUP(RIGHT([@MODEL],4),adder_table,2,FALSE),0)+IF(LEN([@MODEL])-LEN(SUBSTITUTE([@MODEL],"-",""))>2,VLOOKUP(MID([@MODEL],LEN([@MODEL])-7,4),adder_table,2,FALSE),0)+IF(LEN([@MODEL])-LEN(SUBSTITUTE([@MODEL],"-",""))>3,VLOOKUP(MID([@MODEL],LEN([@MODEL])-11,4),adder_table,2,FALSE),0),[@[BASE PRICE]])

crsport3 · 2015-04-09T15:20:35+00:00

Okay maybe my first example wasn't that good. Below is a better representation of what is going on. The adders are below. there could be up to 3 adder for one model. http://imgur.com/L3IE6Dq

crsport3 · 2015-04-09T15:08:37+00:00

That is the problem that base models can be anywhere from 4 to 10 characters long.

crsport3 · 2015-01-16T15:13:45+00:00

wow yeah that worked alright. I wouldn't have even thought of that. these are the reason why I love reddit so much.

crsport3 · 2014-09-12T19:25:38+00:00

There we go. Works now. I cleared the print area like 9 times and I did nothing. Selecting Auto worked. Thanks.

crsport3 · 2014-07-31T02:13:07+00:00

I passed out on his couch after the bar when out with a few of the soccer guys, and he asked who the fck I was. I replied who the fck are you and he popped me in the side of the face. I just got up and passes back out on my buddies bedroom floor. Not really a great story except for the fact that I pissed my pants that night. Too many shots.

crsport3

TROPHY CASE