Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to exclude rows not required from my dataset but my expression does not seem to be working.
In data load editor I have created the below column:
IF(DATE(Exp_PODDate) = DATE(Today()),1,0) AS Exp_PODDateTODAY
I have then created the below expression using the above column:
=IF(Exp_PODDateTODAY = 1,Exp_PODDateTODAY)
Could someone please help with what I have done wrong?
Thanks
date() is formatting function it will not round your date
try below
IF(DATE(floor(Exp_PODDate)) = DATE(Today()),1,0) AS Exp_PODDateTODAY
Regards,
Hi Raman,
Can you share a sample data or an app?
Br,
KC
Hi KC,
I have attached qvf file of app.
thanks
date() is formatting function it will not round your date
try below
IF(DATE(floor(Exp_PODDate)) = DATE(Today()),1,0) AS Exp_PODDateTODAY
Regards,
Hi Raman,
As per the data, i dont see "Exp_PODDateTODAY" with value 1. All value is 0.
Once you have value as '1' just uncheck "Include null Values" for Exp_PODDateTODAY in the table.
Br,
KC
Thanks!
I have the column and used the below expression:
Sum({<Exp_PODDateTODAY = {1}>}Exp_PODDateTODAY)