Book if statement
Hi,
My company has entities 2,5,8,N,U,O,X,Z.
When I prepare the loop and if statement in the books;
not sure why I could only use the if statement for N/U/O/X/Z but not 2/5/8.
I have tried different settings but still not working.
Can you share with me how should I write the code if the entity name is purely a number?
Thank you.
(|Loop1Variable| =[2]) Or (|Loop1Variable| =[U])Or (|Loop1Variable| =[O])Or (|Loop1Variable| =[X])Or (|Loop1Variable| =[5])Or (|Loop1Variable| =[8])
(|Loop1Variable| =2) Or (|Loop1Variable| =[U])Or (|Loop1Variable| =[O])Or (|Loop1Variable| =[X])Or (|Loop1Variable| =5)Or (|Loop1Variable| =8)
Finally I fixed it by not reading the entity name but its member property of its currency:
(XFMemberProperty(DimType=Entity, Member=|Loop1Variable| , Property=Currency) = [USD])
