Forum Discussion

PaulMcDk's avatar
PaulMcDk
Frequent Visitor
5 years ago
Solved

DIVIDE and PERCENTAGE

Dear community,   i'd need your support as i'm trying to do - apparently - a very easy thing but ... i can't 🙂 I have a table loaded with 2 simple measures: count number of trips. I created anot...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    PaulMcDk , Try like

     

    divide([Trip Actual] -[Trip Budget] , [Trip Budget] , blank())

     

    or

    if(isblank([Trip Actual] ) || isblank([Trip Budget]), blank(), divide([Trip Actual] -[Trip Budget] , [Trip Budget] , blank()) )

     

amitchandak's avatar
amitchandak
Super User
5 years ago

PaulMcDk , Try like

 

divide([Trip Actual] -[Trip Budget] , [Trip Budget] , blank())

 

or

if(isblank([Trip Actual] ) || isblank([Trip Budget]), blank(), divide([Trip Actual] -[Trip Budget] , [Trip Budget] , blank()) )

 

PaulMcDk's avatar
PaulMcDk
Frequent Visitor
5 years ago

thanks!

first like did work

 

p