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?   ...
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?

    • Vvelarde's avatar
      Vvelarde
      Community Champion
      9 years ago

      something like this?

       

      • LiorG's avatar
        LiorG
        Frequent Visitor
        9 years ago

        Exactly like this! :-) 

        how do I do it?