I am trying to write a rule in TM1.
The calc is:
['Opportunity Probability'] = s:
IF ( ['APPROVAL for Uniprom'] @<> '','Absolute',['<<<Opportunity Probability']);
All of the elements are strings. When I validate this I get the error "Syntax Error xxxx Logical expression"
Is it possible to compare string values? I think the issue is with the element @<> part.
Any help greatly received.
Hi,
For some reason the rules syntax checker is only accepting external (DB) area reference notation for string areas - so instead of ['APPROVAL for Uniprom'] you should write DB('yourcube', ..., 'APPROVAL for Uniprom'). This will also apply to the ['<<<Opportunity Probability'] reference.
Michel
Yep that works perfectly. Thanks very much.