Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to write below expression
if(Days <= '10',
sum( {$<[FY]={"=$(vCurrentFY)"}>} Sales1 and sales 2)/ Sum({$<[FY]={"=$(vCurrentFY)"}>} qty)
,
sum( {$<[FY]={"=$(vCurrentFY)"}>} Sales1 )/ Sum({$<[FY]={"=$(vCurrentFY)"}>} qty)
howto write sum of sales1 and sales2 in one sum set analysis expression
hi
try like this
if(Days <= '10',
(sum( {$<[FY]={"=$(vCurrentFY)"}>} Sales1 )+sum( {$<[FY]={"=$(vCurrentFY)"}>} sales 2))/ Sum({$<[FY]={"=$(vCurrentFY)"}>} qty)
,
sum( {$<[FY]={"=$(vCurrentFY)"}>} Sales1 )/ Sum({$<[FY]={"=$(vCurrentFY)"}>} qty)
if both fields sales 1 and sales 2 are in the same table than you can also use
if(Days <= '10',
(sum( {$<[FY]={"=$(vCurrentFY)"}>} Sales1+ sales 2))/ Sum({$<[FY]={"=$(vCurrentFY)"}>} qty)
,
sum( {$<[FY]={"=$(vCurrentFY)"}>} Sales1 )/ Sum({$<[FY]={"=$(vCurrentFY)"}>} qty)