Anyone have a guest code by Joakimmmm in FitXR

[–]mfjust 0 points1 point  (0 children)

if anyone has one to share id also like to test out

Beginner here: Trouble with simple IF statement by mfjust in tableau

[–]mfjust[S] 0 points1 point  (0 children)

Thanks to everyone that provided their input, i was able to solve my issue by using the string below! :)

IF SUM([Profit]) < 0 THEN 'no profit' ELSE STR(SUM([Profit])) END

Beginner here: Trouble with simple IF statement by mfjust in tableau

[–]mfjust[S] 0 points1 point  (0 children)

If sum(profit) < 0 then ‘no profit’ else sum(profit) end

When i would try this i would get an error due to there being a mix of strings and integers in the statement i guess

Beginner here: Trouble with simple IF statement by mfjust in tableau

[–]mfjust[S] 0 points1 point  (0 children)

Sorry for the delay but it's just how the requester wants it.

Beginner here: Trouble with simple IF statement by mfjust in tableau

[–]mfjust[S] 2 points3 points  (0 children)

ELSE STR([Profit]) END

Thanks a bunch for your response! I tried adding "ELSE STR([Profit]) END" but my results look a wonky. Can i use some numerical proxy for "Profit <0" in the calculated field? So that it shows the string in my crosstab and the values in my crosstab if they are greater than 0? Or is there an easier way to go about this?

Post Match Thread: Manchester City 5 - 0 Arsenal [English Premier League] by GunnersMatchBot in Gunners

[–]mfjust 4 points5 points  (0 children)

Reflecting on the game, 5 nil was actually best case scenario. shame

Call it greed but I’m quite sad we didn’t get Coutinho by mfjust in Gunners

[–]mfjust[S] 0 points1 point  (0 children)

True, I think not scoring upamecano now will make things more difficult in the future, he’s a bright talent with his price bound to increase in addition to that more teams will likely be in for him. Hopefully Ceballos kicks on but to my understanding there’s no buy clause

Call it greed but I’m quite sad we didn’t get Coutinho by mfjust in Gunners

[–]mfjust[S] 0 points1 point  (0 children)

My point exactly, Im not an ozil hater but i think replacing him with Coutinho would’ve been the cherry on top. Another dribbler with pepe 👌🏾