Set Analysis in Text Object

[Anonymous]

Hello!  I have  a text object with a formula =money((sum({<Aspect={'Actuals'}>}[Total Value])/(((today()-min(DateKey))+1)*7)) .   In this formula. I only want to get the Total Value of Actuals /no of days ... This one works if I select the Actuals in the Aspect box.  However,  it recalculates when I select  other aspects  (not actuals) for which I don't understand how its being computed where it shows weird figures.   Thus, is there any way  to freeze the value at the actuals aspect  or to disregard  any selections under Aspect object?

Pls. help...

[Sokkorn]

Hi

Try =money((sum({1<Aspect={'Actuals'}>}[Total Value])/(((today()-min(DateKey))+1)*7))

Regards,

Sokkorn

[Gysbert_Wassenaar · Accepted solution]

Maybe this is what you want:

=money((sum({<Aspect={'Actuals'}>}[Total Value])/(((today()-min({<Aspect={'Actuals'}>}DateKey))+1)*7))

[Anonymous]

Thank you  for saving me twice, Gysbert...This is what I actually need ! ..

[Anonymous]

Gysbert,

Can you explain to me why  you add a set  analyisis  on this statement (((today()-min({<Aspect={'Actuals'}>}DateKey))+1)*7)) ?  I really don't quite get it why you used the Aspect={'Actuals'}.... 

Actually,  I have another text object with almost the same concept .  I used this  statement but it didn't work.