Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if (Match([SC_FUEL_TYPE],'DMA'), sum(num(FUEL_MASS_BEFORE_SOUNDING/ 1000, ' ####.###', '.', ',' )),
if (Match([SC_FUEL_TYPE],'DMB'), sum(num(FUEL_MASS_BEFORE_SOUNDING/ 1000, ' ####.###', '.', ',' )),
if (Match([SC_FUEL_TYPE],'RMK 500'), sum(num(FUEL_MASS_BEFORE_SOUNDING/ 1000, ' ####.###', '.', ',' )),
if (Match([SC_FUEL_TYPE],'RMG 500'), sum(num(FUEL_MASS_BEFORE_SOUNDING/ 1000, ' ####.###', '.', ',' )),'Unknown'))))
I used this code, but still its not working.Could anyone give a try?
I want to see the sum of individual fuel oil like sum of DMA, or RMD 80 or RMK 700
Should I use totat or aggregate function?
Its working now.I removed some hidden dikmensions
Is it possible to also add records dependent on SOUNDING_DATE? Like what if i want to sum up the values of Computed ROB and Actual ROB dependent on a date and survey id
if (Match([Actual_Fuel_Type],'HSFO'), sum( total {$<Actual_Fuel_Type={'HSFO'}>}FUEL_MASS_BEFORE_SOUNDING/ 1000),
if (Match([Actual_Fuel_Type],'LSDO'), sum( total {$<Actual_Fuel_Type={'LSDO'}>}FUEL_MASS_BEFORE_SOUNDING/ 1000),
if (Match([Actual_Fuel_Type],'HSDO'), sum( total {$<Actual_Fuel_Type={'HSDO'}>}FUEL_MASS_BEFORE_SOUNDING/ 1000),
if (Match([Actual_Fuel_Type],'ULSFO'),sum( total {$<Actual_Fuel_Type={'ULSFO'}>}FUEL_MASS_BEFORE_SOUNDING/ 1000),'Unknown'
))))