Skip to Content
0
Former Member
Dec 22, 2011 at 12:09 PM

negative values to be excluded from a report

636 Views

Hi friends,

In a report i have a calculated key figure total quantity. user dont want these negative kg's appearing in the field. total quantity is a key figure

NODIM ( 'Qty- COPA Aquarius' + 'Qty- WBS' + 'Qty - COPA BA' + 'Qty - Old Billing type with BA type' - 'Qty - Use Risk Cancellation' - 'Qty - Usage Billed EPC' )*

user wants the kg's that are negative should not appear in copa.can any suggest what is the appropriate step to resolve this issue.

thanks,

ALI