topic Re: Set analysis, ignore dimension in table in App Development

Set analysis, ignore dimension in table

AnnieV — Thu, 17 Aug 2023 12:06:45 GMT

Hi,

I have a table like this (simplified):

Category	System Type	QTY	Calculation
C1	TypeA1	9000	9000
C1	TypeA2	25000	<25000 - 9000>
C1	TypeB	1200	1200

For certain System Types I need to subtract the quantity of a different system type to get the correct Calculation value.

The measure I tried is:
SUM({$<CATEGORY={'C1'}, SYSTEM_TYPE={'TypeA2'}>} QTY) - SUM({$<CATEGORY={'C1'}, SYSTEM_TYPE={'TypeA1'}>} QTY)

but this returns 25000 for type A2 instead of 25000-9000.
How can I edit the measure so it shows the correct value?

Re: Set analysis, ignore dimension in table

Lakshmanan — Thu, 17 Aug 2023 12:47:02 GMT

Hi ,

Your expression will give correct result on KPI chart . You should handle this subtraction at the backend in script using peek or if statements or variable.

Please mark as Closed if it resolved the issue.

Re: Set analysis, ignore dimension in table

Or — Thu, 17 Aug 2023 13:31:37 GMT

Seems like you should be using Above() for this.

QTY - if(System = 'A1',Above(QTY),0)

Working in whatever conditions you need.

Re: Set analysis, ignore dimension in table

Lakshmanan — Thu, 17 Aug 2023 13:47:09 GMT

i have tried the above function ,but still in straight table ,it shows different output.

Re: Set analysis, ignore dimension in table

Or — Thu, 17 Aug 2023 13:55:22 GMT

I'm not sure what that table is meant to show, exactly, but the Above() formula in the rightmost column doesn't make sense. It seems to only apply Above() to the ID in the first row, and for the first row, there is no Above() because it's, well, first.