subtraction of two non-aggregated measures

Danilo Rodrigues da Silva shared this question ago

Answered

Good afternoon, I have two fields of measures created from a Case When Created / Accepted = "Created" then 1 end

the other is Case When Created / Accepted = "Return" then 1 end

When I create a cross-reference table I need to generate a subtraction of the created minus the return returning the aggregated data, but I am not able to generate the third field of the subtraction and show the aggregate result, would anyone have a suggestion?

The same question

Replies (4)

Guest ●

Hi Danilo,

unless I've misunderstood your reporting requirement, I would say you should be using a "Calculated Total" for your 3rd field:

/QxQU2OMk5moAAAAASUVORK5CYIIA

please let me know if I've misunderstood you or not.

thanks,

David

Reply URL

Danilo Rodrigues da Silva ●

Hi David, I'll try and then I'll let you know.

Reply URL

Guest ●

OK, I await your response...

Reply URL

Guest ●

Hi Danilo,

I'm just wondering whether the Calculated Total did the trick for you and whether you'd like the ticket closed or not?

regards

David

Reply URL