Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Adding two variables then divide by the third

Hi all,

 

Stuck on this one.

 

I have created three variables to work out a cost.

__BASELINE_VALUE, _RPPTBREAKDOWNS and __MEASURE_VALUE



RETURN
IF(
NOT ISBLANK(__MEASURE_VALUE),
CALCULATE(DIVIDE((__BASELINE_VALUE + __RPPTBREAKDOWNS, __MEASURE_VALUE))
)

I'm struggling with the RETURN part. How do I write the formula so I get __BASELINE_VALUE + __RPPTBREAKDOWNS divided by __MEASURE_VALUE?

Thanks team
Need Help
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    Anonymous ,

     

    Try to remove Calculate keyword from your formula and give it a one try.

     

    Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.

1 Reply

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago

    Anonymous ,

     

    Try to remove Calculate keyword from your formula and give it a one try.

     

    Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.