Set Analysis and If

[alec1982]

Hi Guys,

I am trying to build an expression inside a text box as follow:

=if(Weekend(DateLL)>Date(Today()-7) and Weekend(DateLL)<Date(Today()),Count({$<[DateType]={"RFS"} >}[Name]))

For some reason it is not working..

I have tried to put only Count({$<[DateType]={"RFS"} >}[Name])) and got the nrs,

and I have tried to put if(Weekend(DateLL)>Date(Today()-7) and Weekend(DateLL)<Date(Today()),0,1) and it works..

But whenever I put them together I dont get the right nr..in fact I get "-"

Thxs,

Badr

[sivarajs · Accepted solution]

Count({$<[DateType]={"RFS"} >} if(Weekend(DateLL)>Date(Today()-7) and Weekend(DateLL)<Date(Today()),[Name]))

Check your DateLL date format is matching with today() format

[alec1982]

Thxs so much for all your help!