Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
....I use IF statements in the calculation. In my case I have month on rows and I do calculation for actual month and two month ahead. the rest of the month is 0. BUT I would like to have the TOTAL sum for the three months I have.
if ( trim([Kalender månad]) = trim(TodayOne) Sum (Budget)*0.10,
if ( trim([Kalender månad]) = trim(TodayTwo) ,Sum (Budget)*0.25,
if ( trim([Kalender månad]) = trim(TodayThree) ,Sum (Budget)*0.50,0)))
regards mikael
Perhaps this?
sum(aggr(
if ( trim([Kalender månad]) = trim(TodayOne) ,Sum (Budget)*0.10,
if ( trim([Kalender månad]) = trim(TodayTwo) ,Sum (Budget)*0.25,
if ( trim([Kalender månad]) = trim(TodayThree),Sum (Budget)*0.50,0))),[Kalender månad]))