Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am from Germany and we have Ver 8.5.
i have problem with sum and Bookmark
i have two formel:
1) =Sum({$<Calender.Calender.Year={$(=Only(Calender.Calender.Year))}>}{$*BM01} Billing_Header.Billing_Header.Net_Value_Inv)
2) =Sum({$<Calender.Calender.Year={$(=Only(Calender.Calender.Year)-1)}>}{$*BM01} Billing_Header.Billing_Header.Net_Value_Inv)
In the first formel is Calender year for example 2008 indicated with the bookmark and the Net Value and it work Ok.
into second formel is from 2008-1 = 2007 indicated with the bookmark and the Net Value and the formel put the same value as the first. (2008) it is not possibel Calender.Calender.Year -1 and bookmark.
can anybady help?
Thanks
Regards
Shideh
Regards
Hi Shideh
Just a guess here, but you might want to try moving the -1 inside the bracket on the second formula, so it looks like:
=Sum({$<Calendar.Calendar.Year={$(=Only(Calendar.Calendar.Year - 1))}>}{$*BM01} Billing_Header.Billing_Header.Net_Value_Inv)
Hopefully this will help.
Regards,
Nigel.
Hi Nigel,
Thanks.