Forum Discussion

LiorG's avatar
LiorG
Frequent Visitor
9 years ago

Cost Overview

Hello all, 

 

How do I create something like the picture attached, assuming I use SQL data base and have 4 columns:

1- Total Fee, 2- Third party, 3- Travel Expenses, 4- Other

any ideas? 

 

Thanks, 

Lior

9 Replies

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    9 years ago

    LiorG

     

    Hi, youn can obtain the NETFEE uSing a Calculated Column:

     

    NetFee =
[TotalFee]  - [ThirdParty] -[TravelExpenses] -[OtherExpenses]

     

    • LiorG's avatar
      LiorG
      Frequent Visitor
      9 years ago

      Thanks Vvelarde

      my problem here is more how to create such shape of a graph, the net fee can stay blank if needed

      as long as I can get it to look like the picture attached.

      any idea how can I create i?