Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Its very simple task but i didn't get the correct answer
i have field of one_day_earning and i want to multiply that column with 365 to get Earning
i.e
11* 365 = 4015
but i get 4117
@mahnoor1279 what expression you are using?
sum([ONE_DAY_EARNING]) *365
is this okay?
@mahnoor1279 looks like your earnings column has decimal values. try to floor the values like below
floor(sum([ONE_DAY_EARNING])) *365