BI Publisher Excel Template Issue

Question

Summary

Content

Hey,

I want to fetch run time user values from excel fields and use that field's value in calculation so that when user will enter the value in these columns then calculation will automatically done based upon user values and will display the result.Can you please tell me that is that possible in BI Publisher excel/RTF Templates or is there any workaround for that ??

Please reply as soon as possible.

Mehak Arora · Answer

I want to achieve the result as we perform calculation in excel. For e.g. In the first two fields, I have entered values as 2,3 and in the third field i have performed calculation as product(first_field,second_field). So when the user will enter the values in the field,it automatically generates the result.Please tell me how it is possible in Excel template of BI Publisher as for one field value,it is giving value but for multiple fields, it is fetching only the same value where i have defined this calculation.

I think we have to define range for the same but don't know how ?

User910243567 · Answer

3612780 wrote:Hey,I want to fetch run time user values from excel fields and use that field's value in calculation so that when user will enter the value in these columns then calculation will automatically done based upon user values and will display the result.

Can you explain with an example, Do you want to display User entered parameters in your report.? If that is the case then you need to fetch the values in Data Template query and display the same.