0

Jetreports/Excel formula

Jet Reports Historic Posts

March 05, 2013 07:51

None

Follow

Hi,

I am modifying a JetReports. May I ask a suggestion? How do I manage my multiplier that depends on the AsOfDate?

For example:

1. As of date: 01/02/2013
Value: 500

Solution := 500 * 1 = 500
when I run the report, the value will multiply depends on the As Of Date(January)


2. As of date: 02/01/2013
Value: 500

Solution := 500 * 2 = 1000
when I run the report, the value will multiply depends on the As Of Date(February)

1. As of date: 03/02/2013
Value: 500

Solution := 500 * 3 = 500

when I run the report, the value will multiply depends on the As Of Date(March)

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts March 05, 2013 08:16 Official comment

  Hi MTR,
  
  I think this is possible with an Excel function:
  =MONTH(C4)*500
  Where C4 is where your As Of Date is.
  
  The Month() formula of Excel will only gets the number of the month depending on the given date.
  Try it out!
  
  Regards,
  Bert

• 0
  
  Jet Reports Historic Posts March 05, 2013 08:40

  It worked! Thank you so much!