subtraction of two non-aggregated measures

Danilo Rodrigues da Silva shared this question 15 months 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?

Comments (4)

photo
1

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

photo
1

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

photo
1

OK, I await your response...

photo
1

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