is it possible to formulate if statement something like " if c then (t + w) else f "

[acaryasin01]

Hello, 

is it possible to formulate if statement something like " if c then (t + w) else f "

Or is there another solution to find desired outout?

I am trying to create a something like "If c then (t + w) else f ."

if [Quata]-[Count]<=0 then ([Quata]-[Count]) & "Exceeded" else Not Exceeded endif

I want to return a Quata Control based on the values in three columns.

Costomer	Count	Quata	Quata Control
A	23	30	Not Exceeded
B	15	10	5 User Exceeded
C	5	1	4 User Exceeded

I know I can do it by adding two more column then concatenate them. but I wonder If there is another simple solution!

Costomer	Count	Quata	Quata Overrun	Over run Y/N	Quata Control
A	23	30	10	Not Exceeded	Not Exceeded
B	15	10	-5	Exceeded	5 User Exceeded
C	5	1	-4	Exceeded	4 User - Exceeded

Any help would be appreciated

[atcodedog05 · Accepted solution]

Hi @acaryasin01 

You can use single formula like this

IF [Quata]-[Count]>=0 THEN "Not Exceeded" 
ELSE ToString(ABS([Quata]-[Count]))+" User Exceeded" ENDIF

Workflow:

Hope this helps : )

[Luke_C · Accepted solution]

Hi @acaryasin01 

This formula should do the trick - you need to use a tostring function on the number in order to get it to play nicely with the text.

If [Quata]-[Count]<=0
then tostring(abs([Quata]-[Count])) + " Exceeded"
else "Not Exceeded"
endif

[acaryasin01]

Wonderful👌👌👌

It works. Thank you so much 👍☺

[atcodedog05]

Happy to help : ) @acaryasin01 

Cheers and have a nice day!