Hi Gurus,
I have created logic accounts and the task i am stuck is where i have to assign multiple accounts in one row separated by comma. These accounts contain wildcards characters however I need to group the total generated from these account into one row. I have selected like mapping
Item Description Type Criteria Value Operator Value/Exp Seq Export
Neg1 Like ???_101,???_109 Function If CurVal>0 Then Result =Curval Else
Result="Skip" End If 0 Selected
Pos1 Like ???_101,???_109 Function If CurVal<0 Then Result=CurVal Else
Result="Skip" End If 0 Selected
I can not see any result after setting up the above when data is imported. With the above settings my setup will be short and tidy without which it will run into '000 lines and difficult to maintain.
Can anyone let me know what am i doing wrong or is there any other way to get the desired result.
Please reply urgently, need to resolve this as quickly as possible.
Regards
Prince