Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to calculate 7 columns in the Front End, (not in the script). Out of 7 calculated columns, I have calculated 6 columns, but not able to create the 7th column (Load Margin $). (Each columns uses the previously calculated column).
I need your help in calculating the 7th column. Sample Data and Formula for each column are in the attached QVW files.
Regards
Sujay
I am getting this
Using this
Sum(TOTAL <[Load ID]> Aggr(
((((([Shipment Space]/[Total Load Space])*[Total Load Cost])/Sum(Distinct TOTAL <[PO Number]> ([Shipment Space]/[Total Load Space])*[Total Load Cost]))*[Shipment Charged Amt])-(([Shipment Space]/[Total Load Space])*[Total Load Cost]))
,[Load ID], [PO Number]))
I am getting this
Using this
Sum(TOTAL <[Load ID]> Aggr(
((((([Shipment Space]/[Total Load Space])*[Total Load Cost])/Sum(Distinct TOTAL <[PO Number]> ([Shipment Space]/[Total Load Space])*[Total Load Cost]))*[Shipment Charged Amt])-(([Shipment Space]/[Total Load Space])*[Total Load Cost]))
,[Load ID], [PO Number]))
Hi Sunny,
Thanks for your help. Its worked.
Regards
Sujay