How calculate the sum of the current today with filters, how use TODAY () function of correct form

[JesusAlv4]

Hi Everyone,

I need to obtain production information with a filter by TECHNOLOGY and TURN, the filters are fine but when entering a filter that is today, it does not work.

Data field of date is = TimeIn

Example.

Sum({<[TimeIn]={"<=$(=Date((Today(1)),'DD/MM/YYYY'))"}, XnAreaDescription ={TECNOLOGIA_GN}, TurnoAMPM={AM}>}PRODGOALS)

Regards,

Jesus

[Durgadevikumar]

Hi,

Can you try this,

Sum({$<[TimeIn]<={'$(vDate)'}, [XnAreaDescription]= {'TECNOLOGIA_GN'}, [TurnoAMPM]=  {'AM'}>}PRODGOALS)

here create the one variable 

vDate= Date(Date#(Today(),'MM/DD/YYYY'),'DD/MM/YYYY')

Regards,

DurgadeviKumar

[sathishbabu_s_g]

Try like this for date:

=sum( {1<[TimeIn] = {"<=$(=Date(Today(), 'MM/DD/YYYY'))"}>} PRODGOALS)

[JesusAlv4 · Accepted solution]

I'm sorry to reply late, the solution was as follows:

To the date field, remove the time, using the Onlydate field, and create a sentence where if the result is ZERO remove it from the result.

Also enable in the Dimension tab the check box "Delete when the value is null" in the three dimensions "XnAreaDescription, WRKCTRID, ITEMID"

The TurnoAMPM field filter I only need the AM information, it is important to put the fields where they want to replicate the filter, example: "XnAreaDescription, WRKCTRID, ITEMID"

Sum (Aggr (If (Sum ({<OnlyDate = {'$ (= Date (Today (1)))'}, ShiftAMPM = {AM}>} QTYGOOD) = 0, 0, Sum ({<OnlyDate = {' $ (= Date (Today (1))) '}, ShiftAMPM = {AM}>} PRODGOALS)), XnAreaDescription, WRKCTRID, ITEMID))

thanks to everyone.