Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have an IF statement at the moment which works. In the second clause of the IF statement I want to round the number to 2 decimal places (see below) , and when I do this i get the error 'Error in expresison. If takes 2-3 parameters. I dont get this error until i put the round clause around the sum statement.
Can you help?
Thanks
=IF
(fabs((sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},
bud2 = {110,111,112,113,114,123,124,300,310,320,330,340,200,120,121,122,130,140,160,150,260} , busarea = {PE},
Datasource = {'Budget'}
>} GBP)
-
sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},
bud2 = {110,111,112,113,114,123,124,300,310,320,330,340,200,120,121,122,130,140,160,150,260} , busarea = {PE},
Datasource = {'Actual'}
>} GBP)
)
/
sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},
bud2 ={110,111,112,113,114,123,124,300,310,320,330,340,200,120,121,122,130,140,160,150,260} , busarea = {PE},
Datasource = {'Budget'}
>} GBP)
) >1 , '>100%',
round(
(sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},
bud2 ={110,111,112,113,114,123,124,300,310,320,330,340,200,120,121,122,130,140,160,150,260} , busarea = {PE},
Datasource = {'Budget'}
>} GBP)
-
sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},
bud2 = {110,111,112,113,114,123,124,300,310,320,330,340,200,120,121,122,130,140,160,150,260} , busarea = {PE},
Datasource = {'Actual'}
>} GBP)
)
/
sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},
bud2 ={110,111,112,113,114,123,124,300,310,320,330,340,200,120,121,122,130,140,160,150,260} , busarea = {PE},
Datasource = {'Budget'}
>} GBP)
)
,0.01)
I think its because the braces are not closed properly , plz try below:
round(
(sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},
bud2 ={110,111,112,113,114,123,124,300,310,320,330,340,200,120,121,122,130,140,160,150,260} , busarea = {PE},
Datasource = {'Budget'}
>} GBP)
-
sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},
bud2 = {110,111,112,113,114,123,124,300,310,320,330,340,200,120,121,122,130,140,160,150,260} , busarea = {PE},
Datasource = {'Actual'}
>} GBP)
)
/
sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},
bud2 ={110,111,112,113,114,123,124,300,310,320,330,340,200,120,121,122,130,140,160,150,260} , busarea = {PE},
Datasource = {'Budget'}
>} GBP),0.01
)
I think its because the braces are not closed properly , plz try below:
round(
(sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},
bud2 ={110,111,112,113,114,123,124,300,310,320,330,340,200,120,121,122,130,140,160,150,260} , busarea = {PE},
Datasource = {'Budget'}
>} GBP)
-
sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},
bud2 = {110,111,112,113,114,123,124,300,310,320,330,340,200,120,121,122,130,140,160,150,260} , busarea = {PE},
Datasource = {'Actual'}
>} GBP)
)
/
sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},
bud2 ={110,111,112,113,114,123,124,300,310,320,330,340,200,120,121,122,130,140,160,150,260} , busarea = {PE},
Datasource = {'Budget'}
>} GBP),0.01
)
Many thanks that worked