Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Varis
Is it correct syntactically to have Sum inside Sum? - I have never used that as I can recall.
When I try it in a simple table chart it does not work anyway.
/g
How the variable is defined?
The variable is complicated, it starts like this:
if(ReportRow_EB = 'Heating sales end customer, fixed fee'
,Sum({< EB_PURPOSE_CODE *= {'FAST','EFFEKT'} >} [EB_ACTUAL_KKR] *$(v_RapportStandard) ),
if(ReportRow_EB = 'Heating sales end customer, variable fee'
,Sum({< EB_PURPOSE_CODE *= {'FLÖDE', 'ENERGI', 'INGET'} >} [EB_ACTUAL_KKR] *$(v_RapportStandard) ),
if(ReportRow_EB = 'Heating sales distributors, fixed fee'
,Sum({< EB_PURPOSE_CODE *= {'FAST','EFFEKT'} >} [EB_ACTUAL_KKR] *$(v_RapportStandard) ),
.
.
.
Hi Varis
Is it correct syntactically to have Sum inside Sum? - I have never used that as I can recall.
When I try it in a simple table chart it does not work anyway.
/g
Hi Varis
try to move
Month = {'<= $(v_MaxMonth)'}
inside the set expressions in the v_EB_Actual_KKR variable
and remove the outer sum so the expression would just be:
= $(v_EB_Actual_KKR)
hth/gg
I tried to have Sum inside Sum and it didn't work, propably theere my error is.
Thank you for the help.