Skip to main content
C
colba5776
March 5, 2025

Adding Gross Profit as a Column in a Bar Graph (BI Viewer)

  • March 5, 2025
  • 2 replies
  • 0 views

I was wondering if it's possible to include Gross Profit as a column in a bar graph in BI Viewer. Specifically, I want to calculate Gross Profit as the total Revenue minus Expense accounts and display it as a separate bar in the chart.

I've tried using Calculated Fields, but I haven't been able to get the total to appear correctly in the visualization.

Has anyone successfully done this in BI Viewer, and if so, what approach did you use? Any help would be greatly appreciated!

2 replies

S
Sergey
March 6, 2025

Do you mean somehting like this ?

I did the definition like this :

To create a chart for a specific set of value I always use a calculated fields with a iif statement, like this one : iif([Account]='MyAccountName'  And [UD5]='MyUD5Name',[Amount] , 0)

Hope this helps :)

C
colba5776Author
March 6, 2025

Thank you, this helped out a lot!

Terms & ConditionsAccessibility statement