Hello All,
Hope everyone is keeping well? – I have being asked to create a BAQ and Dashboard to show a Sales Margin in Percentages……
I have Created two “Calculated Columns” one with the total Cost of the Item and the second is the total Sales Value in Euro’s (Some Customer in STG, Dollars and Euro)……
So is it possible to calculate the Percentage Margin between the two “Calculated Columns”
Yes, In your BAQ create a new calculated field, and look for your other calculated fields. You can use them in any calculations. Be wary of divide-by-zero. This can create a server side SQL error without a great description. If you get this error, then make sure to validate your calculated fields for 0 or null before you attempt to use them in calculations.
Good luck!
Here thanks a million for that - I will keep you posted…