[clintjb]

Hi All,
Ive been struggling today with what Im assuming should be a very simple excercise. Basically I have two variables called "cost" and "price" that are fed by previous process steps.

I have a 3rd variable called "margin" that I would like to be automatically calulcated as a percentage of the first two. I assumed at least to get it as a number would be as simple as selecting the text field linked with margin and editing the formula field to something like:

Price / Cost - 100%
or
@@Price / @@Cost

This however doesnt seem to work... Does anyone have any suggestions? Currently Im doing it as JS but it seems like not the best solution.

Secondly (and now Im certain much more complicated) I would like to export a CSV file of this particular instance only. By that I mean a CSV with exactly these three values only and not an extract of the complete DB. Is this at all possible? I only saw documentation linking to complete reports.

Thanks in advanced,

[clintjb]

Hi All,
So I found solutions to both problems and thought I would share in case anybody else has similar issues....

I had the display mode set to "view" which was causing it not to calculate - resetting it back to parent and it works like clockwork.

Secondly regarding the CSV Ive added the following code to the page which has also solved my issue

Code: Select all

var PN = parseInt($("#Number").getValue())
var Cost = parseInt($("#Cost").getValue())
var Price = parseInt($("#Price").getValue())
// The data to put in CSV
var data = [
  ['#Part_Number', '#Cost', '#Price'],
  [PN, Cost, Price],
];

// Loop through the data array and build the csv file to be downloaded
// Each column is seperated by ";" and new line "\n" for next row
var csvContent = '';
data.forEach(function(infoArray, index) {
  dataString = infoArray.join(';');
  csvContent += index < data.length ? dataString + '\n' : dataString;
});

// Content is the csv generated string above
var download = function(content, fileName, mimeType) {
  var a = document.createElement('a');
  mimeType = mimeType || 'application/octet-stream';

  if (navigator.msSaveBlob) { // IE10
    navigator.msSaveBlob(new Blob([content], {
      type: mimeType
    }), fileName);
  } else if (URL && 'download' in a) { //html5 A[download]
    a.href = URL.createObjectURL(new Blob([content], {
      type: mimeType
    }));
    a.setAttribute('download', fileName);
    document.body.appendChild(a);
    a.click();
    document.body.removeChild(a);
  } else {
    location.href = 'data:application/octet-stream,' + encodeURIComponent(content); // only this mime type is supported
  }
}

download(csvContent, 'upload_IMS.csv', 'text/csv;encoding:utf-8');

Hopefully this helps someone else out.
Cheers