Pls help me in the syntax to complete my app

[Green_Bricks_Ho]

[1minManager]

<<IF([Status]=“Y”,“Yes”,“No”)>>

This one is a bit of a guess, not knowing the table structure. But use ANY(Select(… to get one response
<<ANY(Select(Materials[Weekly Total m],TRUE))>>

Simon@1minManager.com

[Green_Bricks_Ho]

HI, Simon Robinson,
Thanks for your reply this information really helped me a lot.

1. <<IF([Status]=“Y”,“Yes”,“No”)>> this works issue solved.
2. <<ANY(Select(Materials[Weekly Total m],TRUE))>>
   I am getting the value of first cell of the amount 550 instead I want the total of the previous 7 days total amount ( which I have computed with the formula using select and sum function "SELECT(materials [AMOUNT], [DATE] > Today() -7) " in a virtual column [Weekly Total m]
   I want the value if [Weekly Total m] only once which is a virtual column .

Please help me in this.
Thanks in advance
Praveen

[1minManager]

To make it easier for me to help, list the TableName[ColumnName] that are relevant here with their formuals and I’ll try to help further. Probably simple, but i’m stuck struggling to understand your data structure

[Green_Bricks_Ho]

[1minManager]

Ok. Try taking out the <<START… and <> statements leaving just the <<[Weekly Total m]>> in

[1minManager]

< < END > > statements

[Green_Bricks_Ho]

No report is generated. mail action not triggered.

[1minManager]

Try <<ANY(Select(Materials[Weekly Total m],[DATE]>Today()-7))>>

[Green_Bricks_Ho]

Getting the value of 550 (first amount value of the selected range instead of total)

[1minManager]

If you want a sum of all the [Weekly Total m] figures then simply change to:

<<SUM(Select(Materials[Weekly Total m],[DATE]>Today()-7))>>

[Green_Bricks_Ho]

getting different value not the sum for the week

[Green_Bricks_Ho]

**<<SUM(Select(Materials[Weekly Total m],[DATE]>Today()-7))>>**result 65170
<<SUM(Select(Materials[Weekly Total m],[DATE] = Today() ))>> result 0

[Suvrutt_Gurjar]

Maybe try wthe following

<<SUM(Select(Materials[Amount],[DATE] > Today() -7))>>

The expression is same as your VC [Weekly Total m].

Instead of adding up in VC and then trying to place that VC in template, you may wish to have that expression in the template itself.

[Suvrutt_Gurjar]

Oh, our posts were almost at the same time.

Nice to know you solved it. All the best with your app.

[Green_Bricks_Ho]

Thanks Suvrutt_Gurjar thanks for your input

[1minManager · Accepted solution]

<<SUM(Select(Materials[Weekly Total m],AND([DATE]>=Today()-7,[DATE]<=Today())))>> ?

[Green_Bricks_Ho]

1minManager:

<<SUM(Select(Materials[Weekly Total m],AND([DATE]>=Today()-7,[DATE]<=Today())))>> ?

result 65170
<<SUM(SELECT(materials [AMOUNT], [DATE] > Today() -7))>> this works
result 4655

[Green_Bricks_Ho]

thanks for opening the blockage
with love Praveen
thanks for spending your valuable time in this issue

[Suvrutt_Gurjar]

Hey Praveen,

You are welcome. My suggestion is to please allocate the solution to yourself and @1minManager.

I just posted when you had already come up with the solution and Simon helped you with the other requirement.

[Green_Bricks_Ho]

<<SUM(SELECT(materials [AMOUNT], [DATE] > Today() -7))>> this WORKS

Direct sum removed the [Weekly Total m] virtual column.

Thanks