how to get yes and no quantity % in a table

[SelflearningBi]

I am using this formula, but I only get 100% for all color, how to show YES %  / NO % 
HOW FAR FROM         YES Qty  vs.  Grand Qty 
Here is how it shows in EXCEL and this is the correct way I suppose to get:

[Luuky]

Hi @SelflearningBi ,

Look into the IF or SWITCH statement:

IF(<logical_test>, <value_if_true>[, <value_if_false>])

SWITCH(<expression>, <value>, <result>[, <value>, <result>]…[, <else>])

With this you can choose a value that needs to be shown if the result of the logical test is true or false. 

If you mean that you want to see values instead of percentages then change the format in the Data tab to the correct one:

Hope this helps!

greetings,

Luuk