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
Solved! Go to 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 : )
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
Wonderful👌👌👌
It works. Thank you so much 👍☺
Happy to help : ) @acaryasin01
Cheers and have a nice day!