I want to create a if function, in which the logical test is a contains function. If the result from contains function is TRUE => put a value from a dimension, if the result is FALS => put another value from a dimension.
I tried to do that like this (in a column dimensioned into FF_fg_non_Ankorstore, supporting the logical test): IF((CONTAINS("FF",TL_OLC.'Lb Charge Type')= TRUE,FF_fg_non_Ankorstore."FMV",FF_fg_non_Ankorstore."AKS")
But it is not working. Could someone help me on that ? Thanks a lot!
I need some more details like:
this should work well. So Abhilash is right we need to know where you are typing it. Is it a property of TL_OLC ?
sorry for the delay!
It does not work like this
Could the issue be that you have 3 opening parentheses but only 2 closing parentheses?
Yes it is… thanks a lot!!