Skip to Content
avatar image
Former Member

How to use NODIM() ?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Mar 14, 2008 at 10:59 AM

    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

    Add comment
    10|10000 characters needed characters exceeded