formula Result.

[Former Member]

Hi All,

Could you please help me here, though my Daily ware house report shows 100% for dispatch quota(Delivers and lines): there is still 1 open order left.by the way the below formula have an impact on the result.

'Dispatched Delieveries according to Plan' + 'Dispatched Delieveries before Plan' ) %A 'Planed Deliveries for Dispatch'

Thanks,

V.singh

[Former Member · Accepted solution]

Hi,

Meaning of your formula

( 'Dispatched Delieveries according to Plan' + 'Dispatched Delieveries before Plan' ) %A 'Planed Deliveries for Dispatch'

means

(('Dispatched Delieveries according to Plan' + 'Dispatched Delieveries before Plan' ) * 100) / 'Planed Deliveries for Dispatch'

So accrding to this i guess your

( 'Dispatched Delieveries according to Plan' + 'Dispatched Delieveries before Plan' ) value is equal to 'Planed Deliveries for Dispatch'

that's why you are getting 100%

kindly let me know if you have any question.

Regards,

Ashish

[Former Member]

hi,

Create CKF for the individual components and then use them in the final formula.

If you are using formulas inside formulas then it might not work as you want.

regards,

Arvind.

[Former Member]

Hi,

You can create a copy report and display the individual components in your formulae to find out the values fetched by all three components.

That would tell which of the component is giving incorrect value.

Hope this helps.

Thanks,

Krishnan