You need to sign in to do that
Don't have an account?
Anurag Saxena
Assistance in SAQL
I need to write a SAQL to get the lowest margin of my shipment records:
Here is the formula:
Lowest margin = (Lowest unit price-Cost price of product which has lowest unit price)/Cost price of product which has lowest unit price .
Here is My SAQL-
q = load "Shipment_with_Receiver";
q = group q by all;
q = foreach q generate trunc((((min('Unit_Price__c')-min('Product__c.Cost__c'))*0.01)/min('Product__c.Cost__c')),2) as 'Lowest Margin Calcualtion';
Thanks