{"version":"1.0","provider_name":"Phil Schatzmann","provider_url":"https:\/\/www.pschatzmann.ch\/home","author_name":"pschatzmann","author_url":"https:\/\/www.pschatzmann.ch\/home\/author\/pschatzmann\/","title":"Smart-EDGAR is supporting Formulas now... - Phil Schatzmann","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"AM90t5mYrW\"><a href=\"https:\/\/www.pschatzmann.ch\/home\/2018\/12\/26\/smart-edgar-is-supporting-formulas-now\/\">Smart-EDGAR is supporting Formulas now&#8230;<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/www.pschatzmann.ch\/home\/2018\/12\/26\/smart-edgar-is-supporting-formulas-now\/embed\/#?secret=AM90t5mYrW\" width=\"600\" height=\"338\" title=\"&#8220;Smart-EDGAR is supporting Formulas now&#8230;&#8221; &#8212; Phil Schatzmann\" data-secret=\"AM90t5mYrW\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/www.pschatzmann.ch\/wp-includes\/js\/wp-embed.min.js\n<\/script>\n","thumbnail_url":"https:\/\/www.pschatzmann.ch\/wp-content\/uploads\/2018\/12\/ratios.png","thumbnail_width":819,"thumbnail_height":477,"description":"In the last Blog we demonstrated how we can calculate KPIs with the help of Spark. We have extended Smart Edgar functionality so that we can implement Calculated KPIs directly with the help of formulas. Here is a short demo in Scala which uses formulas the built in &#8216;coalesce&#8217; method [&hellip;]"}