hope someone can point out what i'm doing wrong here... my eyes are melting
i tried breaking the formula down to it's simplist state of an IF statement, so don't mind the results of "1" if true, "2" if false...
Code: Select all
['Ultimate RPC Ratio'] = IF(DB('WP Actual Reporting', !BPF Strategy, !WPMetrics,
ATTRS('BPF Product',!BPF Product, 'LOB'), !BPF Term, !WPChannel, !BPF State,
!WPEvalPeriod, !WPEffectivePeriod) = 'Auto', 1, 2);
['Ultimate RPC Ratio'] is an element of the WPMetrics dimension.
LOB is a text attribute of the BPF Product dimension, populated with results of: 'auto', 'property', or ' '.
i keep getting an error message for the bold section at the end, saying that it's "incorrect logical comparison".