Back to forum list… Back to How Do I?...

Calculate Header field based on Detail (1 reply)

Colin Ash
3 years ago
Colin Ash 3 years ago

Hi , Using IMAN 3.2

After applying a hierarchy is it possible to use a MAP transform to calculate a header field based on the detail fields?

I have a detail field which calculates out of stock items. 1 = Out of stock, 0 = In Stock.

I need to filter the whole record based on whether ANY of the detail lines are Out of Stock. 

I was therefore hoping to have a field on the header which can be marked 1 or 0 based on if ANY detail rows = 1

Thanks

Colin

Erica Malcolm
3 years ago
Erica Malcolm 3 years ago

Colin,

Connect a filter transform to hierarchy. In field mapping tab Header level , create new field with the following formula 

Sum("detailfield", "DetailLines") = 0. This will filter out all orders that have a line that is out of stock.

Please see https://www.realisable.co.uk/support/Documentation/iman-user-guide/Reference/AggregateFunctions.htm# for further information

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close