topic Re: Calculate new records of a table. in App Development

Calculate new records of a table.

Anonymous — Tue, 13 Feb 2018 17:22:46 GMT

Hello.

I have a table with records and I would like work with new recors, the results of some of them minus others.

For example, I want to show the result of orange section minus the green section. I do not know if this is better done in the data load script (add new records in the table), or work in the chart/pivot table expresions . The desired result would be to show the two sections indicated and the new section.

Can someone help me?

Thanks and regards.

Re: Calculate new records of a table.

Digvijay_Singh — Wed, 14 Feb 2018 00:53:35 GMT

Can you share sample qvf and the expected output?

Re: Calculate new records of a table.

Anonymous — Thu, 15 Feb 2018 08:43:08 GMT

Finaly I did:

if([VW_TRV_FER.Producto]='Total larga distancia',Sum( {<[VW_TRV_FER.Producto] = {'Total larga distancia'}>} valor ) - Sum( {<[VW_TRV_FER.Producto] = {'AVE'}>} valor ))

It's works in single chart. But then I tryed put it in other with more restrictions, and it didnt work. The second part passed to be negative in the chart (example: firts chart 12-2 = 10 ; In second chart 12-2 = 12 and -2 ). So it maybe need more investigation.

Thanks and regards.