Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everybody,
I have doubt on sum( ) function.below there is an expression written. in this exp if "#_ClaimsAmount" is not available for @_HFM_Code_Group='P0300000' then it should show the sum of "sum(#_NetSalesValue)+sum(#_Amount_Fixed_Cost)" for @_HFM_Code_Group='P0300000' .
but it is not showing like that instead it shows nothing...
=Sum({$<@_HFM_Code_Group='P0300000'>}(sum(#_ClaimsAmount)+sum(#_NetSalesValue)+sum(#_Amount_Fixed_Cost)))
Please resolve this problem..
waiting for response
Thanks,
Sunil
I have no clue what you're trying to do. However, in set analysis, the literal value needs to be in curly brackets, like this:
={'P0300000'}
You also can't do a sum() inside of a sum(), or at least not without an aggr(), which probably isn't what you're trying to do anyway.
=Sum({$<@_HFM_Code_Group='P0300000'> -1}
I think, not sure though.
Hi,
there is a mistake between ...>}(sum(... - waht does that mean?
=Sum({$<@_HFM_Code_Group='P0300000'>}(sum(#_ClaimsAmount)+sum(#_NetSalesValue)+sum(#_Amount_Fixed_Cost)))
I have no clue what you're trying to do. However, in set analysis, the literal value needs to be in curly brackets, like this:
={'P0300000'}
You also can't do a sum() inside of a sum(), or at least not without an aggr(), which probably isn't what you're trying to do anyway.
if(@_HFM_Code_Group='P03000000',if(#_ClaimsAmount>0,#_ClaimsAmount,(sum({$<@_HFM_Code_Group={'P03000000'}>} #_NetSalesValue)+sum({$<@_HFM_Code_Group={'P03000000'}>} #_Amount_Fixed_Cost))),#_ClaimsAmount)
Will do quite literally what you have described but in agreement with John, i don't think we have enough information to determine if it's what you /need/
Without knowing your dimensions i can't tell if you need the set anaylsis or the sums as i don't know what you are grouping by but i ahve included them so you can get handle on the syntax