topic Re: Help Required Please... in App Development

Help Required Please...

samvile18 — Tue, 12 Sep 2023 13:37:00 GMT

Hi fellow developers - I'm having an issue with some code (which I'm fairly sure, is fairly straightforward!) I just can't seem to get the syntax working!!

I have the following layout of data and I need to create a % pass against each measure:

As you can see each metric has it's own total value - so the measures that align to Cyclops_Address need to use the total for Cyclops_Address...the measures that align to Cyclops_DOB need to use the total for that etc.

I'm using sum(total but that's totalling everything together and not the individual metric totals.

Can anyone out there help please as this one is driving me crazy!!

Re: Help Required Please...

Or — Tue, 12 Sep 2023 13:42:12 GMT

This is a really odd data structure - usually the total would be the sum of rows, not an individual row within the data.

You could probably make this work using something like:

Sum(Something) / Sum({< Measure = {'total'} >} Total <Metric> Something)

Re: Help Required Please...

samvile18 — Tue, 12 Sep 2023 13:46:29 GMT

I completely agree - the layout is mental. For some reason they bring the failures in and then a total row to work against! Very odd, ok, I'll give it a go...thanks for the reply.