The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
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])
4 Replies
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])- JackLacava
OneStream Employee
Not tested, but I would try placing double-quotes around the number.
I am afraid it doesnt work....
I think you need to wrap the parameters in square brackets. Image is of a working if statement in our app. Good luck!
