HI sharma,
Just drag and drop the three characteristics to the row, then you don't want it in you report then change it's display property to hidden.
Then go to column, then create a formula then select on the edit button to edit this formula. In that prompt , below the keyfigure list you will have Variable list, right click on it and create new variable. Select "replacement path" as type of variable and give any one of the characteristics like "Deletion Indicator"in characteristic, then go to 2nd tab and choose boolean value.
In this way you can create the replacement variable and use that in formula to find the status.
The best way is write a field routine in DSO or Cube level to get the status of each record.
Hi,
Create three replacement path formula variables on the characteristics - Deletion indicator,GR Delivery indicator and IR Final invoice indicator with Replacement Rule as 'InfoObject' and Replace with 'Key'.
Use these variables in the Boolean function in a formula for If condition and display the required values.
Regards,
Geeta
Hi ,
If im not wrong , you have a variable to cal the PO older than 6 months,GR Delivery indicatorand IR Final invoice and deletion Indicatorfrom the info provider.
Create a CKF with IF condition of OR(GR Delivery indicator set,IR Final invoice indicator set,Dleteted set) then take the value as 1 .
Use this CKF and restrict it with the variable for older than 6 months and use Exception aggrigation to sum WRT Po numbers
@Sri
