Custom report - custom calculation in summary line

I am creating a custom report and I'd like to add a custom calculation line to the column summary. Picture of what I am hoping to accomplish is shown below. Alternatively, I'd be happy if I could have the "Met" string appear in the last row of calibration standards.

Any idea how to do this?

Top Replies

CuriousJorge over 1 year ago +1

As an alternative I just created a floating box I could move with the desired values. With some tinkering, I got it to look like it is part of the table.
martin.adams over 1 year ago in reply to CuriousJorge +1

Hello, That will work but what value are you displaying? If you want the logic to be if any injection fail it shows unmet then you would need to store and evaluate the logic. I would have a hidden…

0 CuriousJorge over 1 year ago

As an alternative I just created a floating box I could move with the desired values. With some tinkering, I got it to look like it is part of the table.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 martin.adams over 1 year ago in reply to CuriousJorge

Hello,

That will work but what value are you displaying? If you want the logic to be if any injection fail it shows unmet then you would need to store and evaluate the logic. I would have a hidden column that converts met and unmet to 0 and 1. You can then store the value as an aggregator and if the sum is > 0 then show unmet in your box below and met if it is 0.

Marty Adams
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Was this helpful?