Adding two variables then divide by the third

[DRossi]

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

[Tahreem24 · Accepted solution]

@DRossi ,

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.