Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to separate the values of one column into two tables?
the below table contains Average and it contains an average of both positive(+ve) as well as negative(-ve) values.
I need a separate table for Positive(+ve) values and a separate table for negative(-ve) values.
Please Refer the below Screenshots for your reference:
The Expression used in the above table for Average AMPM values:
=num(If(Rolling_7_days.AMPMTemp='AM',
Only({<Rolling_7_days.AMPMTemp = {PM}>} TOTAL<[Rolling_7_days.TGB Name], [Rolling_7_days.File Date]> Rolling_7_days.Counts)
/Only({<Rolling_7_days.AMPMTemp = {AM}>} TOTAL< [Rolling_7_days.AMI TGB ID]> Rolling_7_days.Counts)-1,
Only({<Rolling_7_days.AMPMTemp = {AM}>} TOTAL<[Rolling_7_days.TGB Name],[Rolling_7_days.File Date1]> Rolling_7_days.Counts)
/ Only({<Rolling_7_days.AMPMTemp = {PM}>} TOTAL< [Rolling_7_days.AMI TGB ID]> Rolling_7_days.Counts) -1))
Dimensions:
I need an output Like this:
Anyone help Me so that I will be very helpful for my learning Process.
Thanks,
Muthu
thank you, guys.
I got the answer actually
I used the below Expression to get the answer:
=if(num(If(Rolling_7_days.AMPMTemp='AM',
Only({<Rolling_7_days.AMPMTemp = {PM}>} TOTAL<[Rolling_7_days.TGB Name], [Rolling_7_days.File Date]> Rolling_7_days.Counts) /
Only({<Rolling_7_days.AMPMTemp = {AM}>} TOTAL< [Rolling_7_days.AMI TGB ID]> Rolling_7_days.Counts)-1,
Only({<Rolling_7_days.AMPMTemp = {AM}>} TOTAL<[Rolling_7_days.TGB Name],[Rolling_7_days.File Date1]> Rolling_7_days.Counts)/
Only({<Rolling_7_days.AMPMTemp = {PM}>} TOTAL< [Rolling_7_days.AMI TGB ID]> Rolling_7_days.Counts) -1))>0,
num(If(Rolling_7_days.AMPMTemp='AM',
Only({<Rolling_7_days.AMPMTemp = {PM}>} TOTAL<[Rolling_7_days.TGB Name], [Rolling_7_days.File Date]> Rolling_7_days.Counts) /
Only({<Rolling_7_days.AMPMTemp = {AM}>} TOTAL< [Rolling_7_days.AMI TGB ID]> Rolling_7_days.Counts)-1,
Only({<Rolling_7_days.AMPMTemp = {AM}>} TOTAL<[Rolling_7_days.TGB Name],[Rolling_7_days.File Date1]> Rolling_7_days.Counts)/
Only({<Rolling_7_days.AMPMTemp = {PM}>} TOTAL< [Rolling_7_days.AMI TGB ID]> Rolling_7_days.Counts) -1)))
Output:
Positive:
Negative:
you can suggest me any other way
Thanks,
Muthu