Virtual Column - Canvas App

Like (0) Share

Report

Posted on 5 Jun 2021 11:22:26 by AVTS

538

Team how to derive the the virtual column result in the same query . Tried with follows but could not ,

Following formula.

Test1.Run(User().Email,
JSON(With( {TheTable:
Filter(ShowColumns(Dailyinventory,"crf99_sno","crf99_materialdesc","crf99_materialno","createdon","crf99_bbd","crf99_qty"),DateDiff(createdon, Today(),Days) =0)},
ShowColumns(AddColumns(GroupBy(TheTable,"crf99_materialdesc","NewGroup"),
"Materialno",First(NewGroup).crf99_materialno,
"Qty",Sum(NewGroup,crf99_qty),

"Created On",Last(NewGroup).createdon,
"bbd",Last(NewGroup).crf99_bbd,
"Sap-Stock",LookUp(sapstock,material=First(NewGroup).crf99_materialno ,unrestrictedStock)),

"Created On","bbd","crf99_materialdesc","Materialno","Qty","Sap-Stock")

)))

Tried with adding following code but no luck .

"Diff" , "Sap-Stock" - "Qty"

Any help much appreciated.

Categories:

Using Apps Using Formulas

AI Builder

All responses (4)

Answers (1)

CNT 10,919 Super User 2025 Season 1 on 05 Jun 2021 at 15:20:21

Like (0)

Report

Re: Virtual Column - Canvas App

@AVTS Glad to help!

Please remember to give a 👍 and accept the solution as it will help others in the future.
AVTS 538 on 05 Jun 2021 at 15:12:45

Like (0)

Report

Re: Virtual Column - Canvas App

Yes . It worked. Thank you .
CNT 10,919 Super User 2025 Season 1 on 05 Jun 2021 at 15:00:25

Like (0)

Report

Re: Virtual Column - Canvas App

@AVTS Hope the solution worked!

Please remember to give a 👍 and accept the solution as it will help others in the future.
Verified answer

CNT 10,919 Super User 2025 Season 1 on 05 Jun 2021 at 12:58:10

Like (0)

Report
Re: Virtual Column - Canvas App

@AVTS To add virtual (Calculated) columns, you have to use AddColumns() like this,
AddColumns(TheTable, "Diff", 'Sap-Stock' - 'Qty')