Hi Experts,
in my load script i have an if statement that defines if a po number is example 'Value A' or 'Value B'
the dimension is named as [We Care].
A PO number can have both values on separate so i can have:
po1234 'Value A'
po1234 'Value B'
i have to write an if in the table to state if We Care = value A and Value B the result is value A
however, i cannot associate my effort below to the field PO number
=If([We Care] = 'value A' and 'value B' , 'value A','value B')
can anyone advise on how i can use the above for all values in a PO number as there is no value of value A and value B in a single cell return.
I hope i explained that ok and someone has the answer i'm looking for.
Thanks in advance
Daniel