Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need your help to manage special case found.
In database my field store numbers like 1, 2, 33, 1027.....
In fact, each 2^x represent specific value.
For example:
2^0=1 --> blue car
2^1=2 --> red car
2^2=4 --> orange car
.....
For a customer, this field stores any cars they have. If they have a blue car, value is simple: 1. If a customer have 2 cars, the value is the sum of the two values (example: 6 for a red and orange car). I have lots of combination so it seems impossible to create a pick/match function.
Do you have any idea to extract each single result (cars) in this example please ?
Regards
Regis
@mostal75 wrote:
Hopefully not 🙂
Only 1 color by car in a field line
Hopefully not? What are you saying? I am not sure I follow your question and your data well enough... can you share an image of your data to help us understand what you have?