Forum Discussion
ResearchDev
Helper II
Helper IIHasValue is equivalent to what?
I am trying to convert the below code to a PowerBI Paginated report. What is the best way? If Has value in (:Sample Date) then perform a DateDiff function using Days to count from the difference betw...
ResearchDev , if are looking for power bi, then we have hasonevalue https://p3adaptive.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
ResearchDevHelper II
Helper III use a query instead. Now when using the query in SQL developer it runs fine and show the number of days between but in report builder. I get a CAST Problem is the one in BOLD.
SELECT
T_SMPL.SMPL_ID,
T_SMPL.SMPL_MIX_ID,
T_SMPL.SMPL_DT,
TO_DATE(SMPL_DT,'YYYYMMDD') smpl_dt_disp,
CASE WHEN
T_SMPL.SMPL_DT IS NULL OR T_SMPL.SMPL_DT=0 THEN SYSDATE
ELSE TO_DATE(T_SMPL.SMPL_DT,'YYYYMMDD') END - sysdate Days_Between,
T_PCC.MIX_ID
FROM
SM_ADMIN.T_SMPL T_SMPL
INNER JOIN SM_ADMIN.T_PCC T_PCC ON T_SMPL.SMPL_MIX_ID = T_PCC.MIX_ID