Forum Discussion

colba5776's avatar
colba5776
New Contributor
4 days ago

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

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!

BI Viewer
  • Sergey's avatar
    Sergey
    Contributor III
    3 days ago

    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 :)