Populate value as zero based on product name
Hi ,I have a BI Publisher requirement to populate two different columns based on product name.Column A will be populated with amount X and column B with zero for Product 1.Another scenarion is to populate Column A with zero and Column B with amount Y for Product 2.Th requirement is only for reporting purposes , the amount column is not always zero , only that we are enforcing the zeros to make report look in a ceratin way.The template is an excel - I have done something similar to rtf template but now the template has been changed to excel