Negative Values in Chart

[#1]

Hi All,

In  application There are two dates eg-DATEA  ,DATEB, Requirement is that DATEB-DATEA  we did that  fine  in straight table,

but we are getting negative vaues in some cases, how negative values should show as 0 or dont show any value delete that record

Note:: should do in back end,plz i want logic for this

[#2 · Accepted solution]

Hi satish,

I need some clarification, Are you subtracting dates here?

If you clarify this I will try to post answer.

If my understanding is correct, You can find solution in attached .qvw.

Hope it helps you

BR

Susvith

[MK_QSL]

If((DATEB-DATEA) <0,0,(DATEB-DATEA) ) as FieldName

[maxgro]

rangemax(0, DATEB-DATEA) as newfielddatediff

[#5]

hi,

requirement is dateA and dateB two dates if dateA-dateB(subtraction) then negative values are coming in chart they want to remove negative vale recors from application or change them to zero this shoulb  be in back end

[#6]

Hi satish,

Then I guess I got it right. Did you check the qvw attached ?

BR

Susvith

[#7]

Hi Susvith,

its working,thanku for your time.

[MarcoWedel]

for Null values:

LOAD DATEB,
          DATEA,
          If(DATEB>=DATEA,DATEB-DATEA) as Days
FROM ...

regards

Marco