Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day,
I have a database in QV that are considering the item a and b together. Example, a has 30 units and b has 21 units, but my data is as below:
Header 1 | Header 2 |
---|---|
a | 50 |
b | 1 |
c | 20 |
d | 30 |
How can I create a third header with a condition to consider item a only with 30 units and item b with only 21 units? Is it possible?
Tks and rgds,
Jorge.
load
Header1, Header2,
if(Header1 = 'a', 30,If(Header1='b', 21)) as Header3
from your table...
Hi,
How you got the condition has a=30 and b=21?Is it always 30 and 21?Did you calculated based on some data?
Celambarasan
Actually, i forgot to mention, item a is based 60% for a and 40% for b + b units