Subtracting dates with aggr function

[luiz_damascena]

I have a chart (PivotTable). In it, as dimensions, I display the fake columns "Days1_" - = (Interval (Today () - date_task, 'd')) - and "Media_" - =(Round (aggr (avg (interval (today () (data (today ())) d ')), city_task, burgh_task, phase_task, my_task))).

The values are properly displayed.

But when I create a fake column "Dif_" -

=
(Interval (Today () - date_task, 'd'))
-
(Round (aggr (avg (interval (today () - data_task, 'd'))), city_task, burgh_task, phase_task, my_task))

The result is null. Why?

My ultimate goal is to set background colors (if days1_> media_1, red; if days1_ <media_, green; if days1_ = media_, yellow), but with result null, the test for setting colors doesn't work ...

Thanks in advance for any help.

[Anil_Babu_Samineni]

Is that syntax issue? Or can you share what you are getting using 2 different expressions

=(Interval (Today () - date_task, 'd'))-(Round (aggr (avg (interval (today () - data_task, 'd'))), city_task, burgh_task, phase_task, my_task)))

Please remove red parenthesis and add it in the blue color

[luiz_damascena]

I wrote wrong - the definition of "Media_" is

(Round (aggr (avg (interval (today () - data_task, 'd'))), city_task, burgh_task, phase_task, my_task))

[luiz_damascena]

Thanks, but I believe that I wrote wrong, in the post... in my qvw, the definition is like you wrote, with the parenthesis in the correct position.

[Anil_Babu_Samineni]

What is the out put you've got using both expressions?

[luiz_damascena]

The output is "-", that is the defined as the Null Symbol in Presentation Tab.

[Anil_Babu_Samineni]

Can we have sample application to test ?

[luiz_damascena]

Thanks again, but in this case, I don't know how to do that... it´s a big qvw, with a lot of code on script... I don't know how to generate data to mount the test, to send... I'm sorry, and thanks again.

Why can I see the colums but I can't do a math operation using them? Mind blowing!

[Brett_Bleess]

Luiz, you can use the File\Reduce Data\Keep Possible in the Desktop client, but be sure you make some selections first to be sure there is some data still left in the data model.  If there are any confidential fields as well, use the Settings\Document Properties\Scrambling tab to scramble those...

Regards,
Brett