Sum Original estimate hours

Questions & Answers
1

Hello,

We would like to add a calculation below

Planned hours [custom field] - Original Estimated hours if decision is “Proceed”

Proceed and Do Not Proceed is a custom field

image

Tried this formula but not working as expected.

[Measures].[Planned Capacity with target start]-[Measures].[Original estimated hours with target start]

thanks in advance for your help

2

Hi,

Have you tried the following formula for the calculation using the tuple?

[Measures].[Planned Capacity with target start]
-
(
[Measures].[Original estimated hours with target start],
[Decision].[Proceed]
)

The report should not contain the Decision dimension for this formula to work.

Kindly,
Janis, eazyBI support

1 Like
3

Thanks @janis.plume . This works