How to use NODIM() ?

[suresh_reddy27]

Dear Friends,

I have created CKF using RKFs usiing if and else(Logical OR) ..The formula is below

( ( ( ( ( ( ( 'All Open Items' - 'Invoiced turnover Month M-1' ) < ( 'Invoiced turnover Month M-1' ) * 'All Open Items' / 'Invoiced turnover Month M-1' * 30 OR ( ( 'All Open Items' - 'Invoiced turnover Month M-1' ) < 'Invoiced turnover Month M-2' ) * ( 'All Open Items' - 'Invoiced turnover Month M-1' / 'Invoiced turnover Month M-2' * 30 ) ) + 30 OR ( 'All Open Items' - 'Invoiced turnover Month M-1' - ( 'Invoiced turnover Month M-2' < 'Invoiced turnover Month M-3' ) * ( 'All Open Items' - 'Invoiced turnover Month M-1' - 'Invoiced turnover Month M-2' / 'Invoiced turnover Month M-3' * 30 ) + 60 ) ) OR ( ( 'All Open Items' - 'Invoiced turnover Month M-1' - 'Invoiced turnover Month M-2' - 'Invoiced turnover Month M-3' ) < 'Invoiced turnover Month M-4' ) * ( 'All Open Items' - 'Invoiced turnover Month M-1' - 'Invoiced turnover Month M-2' - 'Invoiced turnover Month M-3' / 'Invoiced turnover Month M-4' * 30 ) ) + 90 OR ( 'All Open Items' - 'Invoiced turnover Month M-1' - 'Invoiced turnover Month M-2' - 'Invoiced turnover Month M-3' ) ) - ( 'Invoiced turnover Month M-4' < 'Invoiced turnover Month M-5' ) * ( 'All Open Items' - 'Invoiced turnover Month M-1' - 'Invoiced turnover Month M-2' - 'Invoiced turnover Month M-3' - 'Invoiced turnover Month M-4' / 'Invoiced turnover Month M-5' * 30 ) + 120 OR ( 'All Open Items' - 'Invoiced turnover Month M-1' - 'Invoiced turnover Month M-2' - 'Invoiced turnover Month M-3' ) ) - 'Invoiced turnover Month M-4' - ( 'Invoiced turnover Month M-5' < 'Invoiced turnover Month M-6' ) * ( 'All Open Items' - 'Invoiced turnover Month M-1' - 'Invoiced turnover Month M-2' - 'Invoiced turnover Month M-3' - 'Invoiced turnover Month M-4' - 'Invoiced turnover Month M-5' / 'Invoiced turnover Month M-6' * 30 ) + 150

When I check Syntax is correct, when I check the query it says a following system error

Diagnosis

Additional elements are added to the item 23 that do not have the same dimension, for example, quantities and amounts or amounts and ratios.

Procedure

Check your definition.

If you the addition is still meaningful, you can hide the dimensionality of one or both partial outputs with the operator 'NODIM'. The system then understands this partial output as a dimensionless number.

I dont know how to use NODIM for each if statement..

I am greatful to your help.

Thanks,

SB

Edited by: Suresh Babu on Mar 14, 2008 11:48 AM

[Former Member]

Hi,

NODIM() function is used for unit conversion. If the keyfigure displays as $100 in the report, using NODIM u can display as 100.

NODIM(KeyFigure)

Hope this helps

Thanks

Sundar