Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have an expression which works and brings the correct numbers on a line-by-line basis but the totals do not agree to the lines above. Why would this be and is there anyway to correct this?
+IF(
SUM(Aggr( sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},pl={"N01","L03","N02","N03","N04","N06"}>}IS_IFRS_GBP),entity_region,entity_description)) >0,
SUM(Aggr( sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},pl={"N01","L03","N02","N03","N04","N06"}>}IS_IFRS_GBP),entity_region,entity_description))
,0)
Many thanks
Paul
May be this:
=Sum(Aggr(If(Sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},pl={"N01","L03","N02","N03","N04","N06"}>} IS_IFRS_GBP) > 0,
Sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},pl={"N01","L03","N02","N03","N04","N06"}>} IS_IFRS_GBP), 0), entity_region, entity_description))
May be this:
=Sum(Aggr(If(Sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},pl={"N01","L03","N02","N03","N04","N06"}>} IS_IFRS_GBP) > 0,
Sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},pl={"N01","L03","N02","N03","N04","N06"}>} IS_IFRS_GBP), 0), entity_region, entity_description))
Thanks so much for that, was very helpful
Paul