<<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))>>
HI, Simon Robinson,
Thanks for your reply this information really helped me a lot.
- <<IF([Status]=“Y”,“Yes”,“No”)>> this works issue solved.
- <<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
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
Ok. Try taking out the <<START… and <> statements leaving just the <<[Weekly Total m]>> in
< < END > > statements
No report is generated. mail action not triggered.
Try <<ANY(Select(Materials[Weekly Total m],[DATE]>Today()-7))>>
Getting the value of 550 (first amount value of the selected range instead of total)
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))>>
**<<SUM(Select(Materials[Weekly Total m],[DATE]>Today()-7))>>**result 65170
<<SUM(Select(Materials[Weekly Total m],[DATE] = Today() ))>> result 0
<<SUM(Select(Materials[Weekly Total m],AND([DATE]>=Today()-7,[DATE]<=Today())))>> ?
<<SUM(SELECT(materials [AMOUNT], [DATE] > Today() -7))>> this WORKS
Direct sum removed the [Weekly Total m] virtual column.
Thanks
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.
Oh, our posts were almost at the same time.
Nice to know you solved it. All the best with your app.
1minManager:
<
result 65170
<<SUM(SELECT(materials [AMOUNT], [DATE] > Today() -7))>> this works
result 4655
thanks for opening the blockage
with love Praveen
thanks for spending your valuable time in this issue
Thanks Suvrutt_Gurjar thanks for your input