Formulae Creation

building reports webintelligence
1

Hi Friends,

I want to create a variable in the WebIntelligence. Below is the scenario for creating the formulae.

If the individual’s resources timesheet for the Time Period End Date has been signed , where the timesheet has been signed and submitted within 14 days of the Time Period End Date, display “1”.

we have objects like resource name, Time period end date, signed.

what is the formulae I have to create. below is the I created forumlae but I am not getting data properly. Please suggest me yaar.

=If(Not( IsNull([Signed On])) And ([Signed On] < RelativeDate([Week End Date];14));1;0).
But I want to include resource name How I can include in the formulae.

Regards,
Eswar

eswar519 (BOB member since 2009-05-26)

2

Moderator Note: Eswar, you could have posted it here itself. Please do not cross-post. It leads to fragmented discussions and is against our forum rules.

Jansi :india: (BOB member since 2008-05-12)